Topic: Links tables together
Hi
I have been working on a small application, and run into a problem that I struggling to fix 'properly'
Structure
Each customer has
Many appliances
Each appliance has many tests
So How do i ensure the each test is linked to one appliance and one customer?
If I insert a counter field, all the existing records wont have that counter value?
Can I I fill in each form in the string with the inherited values... ie use a combo box on an appliance form, and fill it with the customer name that was clicked?
Thanks in advance...
I have attached my database... please excuse all the beginner errors... any suggestions would be appreciated.