Insert only update page & Calc field?
Hi, is it possible to join 2 tables using DA wizard or do I need to manually create recordsets in DW to achieve this? I have 2 tables that I need DA update/insert pages to write to then display the info from both tables in results page?
TblContacts [ContactID] + TblHolidays [HRContactID] contain data about staff holidays and need to allow the update/insert pages to insert data into both.
I tried this with no success:
Used DA wizard based on TblHolidays to create pages. On insert page design I created a new recordset [rsHolidayForm] joined 2 tables added required fields from each table and tested, seems fibne in query window. I then added these fields to the insert page form, opened page and created a new record, the data was added to the TblHolidays but not into TblContacts?
I am sure there must be an easier way to do this, most of my project will be based on each page having multiple tables backend?