Any reason we can't copy and paste txt into here?
I am an intermediate user struggling t re-learn how to setup relationships among tables.
I messed up my real database so I set up the attached, to back track issues. Trying to figure out how to fix relationships in order to accomplish the below:
My dilemmas:
When entering an order using the 'Orders' form, I would like the job number from the main form 'Orders' to copy into the 'order details subform'. It does not, and I believe my relationships are setup right.
When I open table 'Orders' and click the plus sign at the left of each line, I would like to se theitems ordered, from the 'Order Details' table. I had this working on my real database, butnow is not working. I may have messed up the relationships. I want to see this so I know my relatioships are set up right.
tHANkS AND SORRY FOR THE TYPOS. This forum is messed up today.