Okay Peter,
I think I am getting closer to your issue. Can I check:
Do you call the queries from a form, or picking up your description of a mouse, do you simply double click on the queries in a file list and run them?
The coding required to achieve the task you seem to be describing is not...
Okay, I think I can see your thought process.
Two thoughts:
One, I would be tempted to set up just the one table and use calculated fields.
The table would them contain the fields; NAME // SIRE // DAM // ImpactValue //NameValue // SireValue // DamValue.
At data entry when you pressed enter...
Peter, could you give me a clue about how you do this. Is your method coded or do you have separate queries that you run?
I ask this question, because usually, I would expect to be sitting looking at a form of some sort when the basic question gets asked. Regardless of the number of tables...
Could you ask your question a little more clearly? For instance;
are you running the second query using the information generated by the first query?
what is the end use of the information you generate from the two queries?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.