yes I understand the concept of how it works. My question was how come there is no recordset on the insert record page?
I need information from a joined table,but the DA insert record seems to only let you reference one table at a time. In this case the table is "inventory_tbl" that the record is being inserted into, and I want the data from the parent table "dealer_tbl"
Do I need to create a session variable when the client logs in to capture some data from the dealer_tbl? I want to be able to reference the "dealer_folder" column in the "dealer_tbl". But the insert record seems to only look at inventory_tbl.
If creating the session variable is the option, please give me a pointer on how to do it and on which page. i.e. is it the login page or the page that a successful login directs them to?
This question is hard for me to formulate by typing so please be patient.