CammoLammo
New member
- Local time
- Tomorrow, 03:27
- Joined
- Mar 30, 2020
- Messages
- 7
Hi,
I'm making an entry form for orders within my database and I wanted to have combo boxes where the user can select different related entries such as Customer and Product, I used the Add Existing Fields tool to add in these entries and it worked for my Payment Type and Product tables but when I tried to do it for the Customer table it did not work. The relationship between Customer and Order is 1:M and I have this in my relationships section of the database. The Customer table attributes (First Name, Phone Number, etc) will show correctly for existing orders but it will not let me input Customer details for a new order or create a combo box to select between the customers in the database. Please help me!
Thanks!
I'm making an entry form for orders within my database and I wanted to have combo boxes where the user can select different related entries such as Customer and Product, I used the Add Existing Fields tool to add in these entries and it worked for my Payment Type and Product tables but when I tried to do it for the Customer table it did not work. The relationship between Customer and Order is 1:M and I have this in my relationships section of the database. The Customer table attributes (First Name, Phone Number, etc) will show correctly for existing orders but it will not let me input Customer details for a new order or create a combo box to select between the customers in the database. Please help me!
Thanks!