HeadAgainstABrickWall2021
Member
- Local time
- Today, 08:47
- Joined
- Sep 23, 2021
- Messages
- 32
Hi all,
CURRENT KNOWLEDGE LEVEL: Tables and Reports all good, simple queries all good, learning Update Queries and Union Queries, Form formatting all good, comboboxes NOT GOOD.
My database has four tables, with four related forms for data entry:
Customer
Case (multiple cases per customer)
Event (multiple events per case)
Contact (multiple contacts per event)
I have set my Customer ID as the primary key in tbl.Customer, and as a foreign key for all others. Case ID is primary key for tbl.Case, which is foreign key for Event and Contact. Event ID is primary key for tbl.Event, which is foreign key for Contact.
I am trying to achieve two key things at the moment:
1. Use cascading comboboxes in Case, Event and Contact forms to populate Surname and First name, which will then update the foreign keys in that form/table.
2. Trigger a message/warning if the person's name is NOT in tbl.Customers, and request that this be updated BUT still allow data entry (as updates are happening live, there isnt always time to go back and populate the Customers form on the spot, and I'm hoping to reduce the amount of backtracking.
I have followed tutorials online for:
Cascading comboboxes
Bound comboboxes
Query returns
and can get the physical results, but they aren't populating my fields as desired. I currently have a bound combobox in my Case tab which displays the names as I want them too, but wont let me select anything!
Any help would be appreciated - SQL welcome!
With thanks,
HAABW
CURRENT KNOWLEDGE LEVEL: Tables and Reports all good, simple queries all good, learning Update Queries and Union Queries, Form formatting all good, comboboxes NOT GOOD.
My database has four tables, with four related forms for data entry:
Customer
Case (multiple cases per customer)
Event (multiple events per case)
Contact (multiple contacts per event)
I have set my Customer ID as the primary key in tbl.Customer, and as a foreign key for all others. Case ID is primary key for tbl.Case, which is foreign key for Event and Contact. Event ID is primary key for tbl.Event, which is foreign key for Contact.
I am trying to achieve two key things at the moment:
1. Use cascading comboboxes in Case, Event and Contact forms to populate Surname and First name, which will then update the foreign keys in that form/table.
2. Trigger a message/warning if the person's name is NOT in tbl.Customers, and request that this be updated BUT still allow data entry (as updates are happening live, there isnt always time to go back and populate the Customers form on the spot, and I'm hoping to reduce the amount of backtracking.
I have followed tutorials online for:
Cascading comboboxes
Bound comboboxes
Query returns
and can get the physical results, but they aren't populating my fields as desired. I currently have a bound combobox in my Case tab which displays the names as I want them too, but wont let me select anything!
Any help would be appreciated - SQL welcome!
With thanks,
HAABW