Hello,
I'm making a database where I want to fetch a record from a table "Customer Details", from a drop down box in an order form, additionally, if the customer does not exist, I'd like it to add the customer name to "Customer Details" if a user types a name in.
I've managed to do this with other tables, however these are directly linked to the form by a foreign key, however the Customer Details were many-to-many and have been broken up with a weak entity, yet I'm not sure how to get this to work like other parts of the form.
How do I get it so I can link a table via a weak entity?
I'll then be doing the same for Circuit and Site...although one step at a time!
Thank you.
I've attached my Database. =)
Bookmarks