sanders720 (Programmer)What is an relationship that is intermediate? We have two tables

Once I drag InquiryNo through the very first dining table towards the 2nd, I have an Intermediate relationship. The thing I really would like is a single to relationship that is many.

Assistance with this really is greatly appreciated.————————————————————JimHorton (Programmer)For a one-to-many relationship, you must have one of several areas be a distinctive industry, often this is a main Key. the other industry will never be unique, but it is good training to at the very least index it.

In your tables, the initial industry should really be InquiryID in the 1st table, and Customerid should always be a foreign key to your clients dining table (maybe not shown in your example–I’m simply mentioning it on a tangent). You will connect to the inq. date dining table.

Nevertheless it looks such as the very first dining table can be put up with a compound key–Cust id and inq.#, that is okay, then again you will need to place both custid and inq# when you look at the 2nd dining table, and then make the hyperlink on both those industries. This will be okay, but I would suggest the Inquiry # when you look at the first table be unique across ALL inquiries–not simply with this client id.

Each one for the above will be able to work however–the unique INq#, or perhaps the mix of Custid and inq#.–Jim————————————————————sanders720 (Programmer)There are now likely to be 5 tables, but i will be hoping to get three working first. Continue reading Would you mean an “Indeterminate” relationship? That is just what you need to be getting into this instance. →