Help with relationships...
Hi. I am not brand new to this, but I am having trouble wrapping my brain around a problem I have extracting data through relationships. Below is a jpeg of my setup. My problem is with the far right table, "Service Request". On this table, and the layout associated with this table. the user must select a builder and subtrade from drop down lists. Once they select a subtrade, that subtrades details populate each field, like phone, contact, address etc. The drop down list is a local field called "Issue To" from "Service Request table" and is populated using the "Use values from field" option in the value list. The values are grabbed from SUBTRADES::SUBTRADE_ID. This setup works perfectly, as it should. But my question is this...I can't for the life of me make the same setup for builders work. The client can see all of the builders int the dropdown list, but once selected the the information fields (phone, addresss, contact etc) do not populate as they do for subtrades. If I try to link Service Request with builders it tell me I can't because "There cannot be more than one realtionship between any two tables in a graph..." Furthermore, if I break the link to subtrades and move it to builders, the builder dropdown list works perfectly and popluates the builders info after the user selects it. I can't make both work at the same time!!! HELP