Hi Jim, Are you carrying redundant information in your database? If some of the fields in one table are the same as in another table, then you could eliminate one of them and base your form on multiple tables.
Bernie Lis ----- Original Message ----- From: Jim Belisle To: RBASE-L Mailing List Sent: Saturday, March 26, 2011 4:59 PM Subject: [RBASE-L] - [No Subject] I have two tables that have the same type information. When updating one table with a form, I want to be able to update the other table at the same time. Since there are 40 fields and I would not know which field might be edited, what would be the best way to go about this? Would I have to have a compID on all FIELDS then have the update command always update all fields? Any suggestions would be appreciated. All fields are text fields James Belisle
