Auto populate a field in a join table of a many-to-many relationship?
I have a join table Projects for a many-to-many relationship with Project Information and Replicon. I have created the relationships between them. When I go the the Projects_ table and create a new ...
So to make it easier, I took screen shots of the relationships.
I do have test data populated. Since I posted, I managed to get the relevant Replicon code to come over, see below, but what I really want is a field that just shows the Replicon code.
In all instances, the standard QB assigned ID is used, though I renamed it to the table name for clarity.
I still have to choose the project when I open the Replicon table to put in the data. I would like that to just carry over the appropriate data already input into the Projects table (See below).
Sorry for doing it this way, but I figured it would help to clarify things easier if you saw the relationships and the output.
