Jump to content

Drop down lists


This topic is 5653 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am creating a data base which at this point has two tables, Customers and invoices. I want the invoice form to have a drop down list of all the customer's names to choose from. I made the customer name field in invoices a number with lookup to the customer table of its customer name. I related the tables by customer number. This did not work. So I defined a customer "list" which pointed to the customer name field in the customer table. Then I made the customer field on the invoice layout a drop down list pointing to the customer list. This also did not work.

So how do I do this? I cannot find an example of what I would be a common feature in any of various reference books.

Thanks

[email protected]

Link to comment
Share on other sites

Not sure if the attached file will help but have a look. The drop down list is defined in Value Lists. There is no file password but you may need to enter Guest as the user.

If you wanted the customer name in invoices could be a lookup from customers based on Customer_ID.

Cheers Pedro :-)

Sample.zip

Edited by Guest
Link to comment
Share on other sites

  • Newbies

This is very interesting. It works but I would have thought one would make the customer name field the one with the drop down list. I will study your example. Thanks.

We are ptobably going to visit

Australia later this year. How is the weather in October-November? :

Link to comment
Share on other sites

The link between the tables is the Customer_ID so this needs to be selected in the invoices table. Creating a value list using both Customer_ID and Customer Name but only showing Customer Name allows the user to select by name.

We are ptobably going to visit

Australia later this year. How is the weather in October-November? :

Depends what areas you're visting as the climate varies, most areas should be good that time of year :-)

Cheers Pedro :-)

Link to comment
Share on other sites

This topic is 5653 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.