Search results

I just read in another thread about enforcing referential integrity between tables so that deleting a record in a primary table won't leave orphans in a subordinate table. I was able to edit the relationship for one subordinate table to enforce referential integrity (cascade update and cascade...

I have a membership database. The names and addresses are in the Members table, and I have three other tables (linked by a membership number) for email addresses, phone numbers, and notes. These are set up in the Members table as subdatasheets. I have these additional tables so that I can...

How do I set up a date field so that it changes to the current date whenever any other field in the record is changed?

I have a membership database. A number of members go by their middle names or a nickname rather than their first name. I need to keep track of their real full names, but I want the new-record default of the preferred name field to equal the contents of the first name field. How do I set this...