I have a form that puts information into multiple fields of the "databasehistory" table. Within this same form I would like to have the ability to write information to the "apstatus" field of the "databaseparents" table. I would like to do this without a subform as this form needs to be in continous mode. I tried to add the "databaseparents" table to the record source of the form but ended up with a bunch of '#name' results in all my fields. I don't know if I need to set up a relationship (this concept I have never grasped thus have never done it).
Is what I want to do possible?? I know enough to be very dangerous but not nearly enough to solve the simpliest of issues. Thank you in advance for your help.
Is what I want to do possible?? I know enough to be very dangerous but not nearly enough to solve the simpliest of issues. Thank you in advance for your help.