AnsweredAssumed Answered

Reference problem...

Question asked by admagic on Oct 10, 2015
Latest reply on Oct 10, 2015 by bigtom

I know this is probably an amateur problem, but that's what I am! I have a table of components and another table of systems that use those components. They are linked by Component Name and I select components from a drop-down list (based on a Values List derived from component names) in the system table. The problem is that any time I select a component for a system (from the systems table) it generates another (blank, except for the component name) entry in the components table and thus doesn't carry across any of the other information on the component table for that component. It also results in a duplicate entry. If I delete that duplicate, the system table record that carried itr goes blank. I cannot select the actual component. I also have a reference field in the components table that tells me what systems it is used in, so I think I'm dealing with some sort of circular reference, but I can'[t work out what to do...can anyone help? I'm happy to send the database for you to look at...I'm flummoxed! Thanks...

Outcomes