Hello,
I'm building a database for all contracts received daily , I created two tables 1.Contract-Info.tbl (for general contract info) and 2.Contract-history.tbl (for history per client). I want to create a popup or subform where I can view the client's history every time I log new data for the existing client. how can i achieve this. (should i create separate fields in my form per table?..im so confused..please help