I have a database into which I originally imported a set of records.
Subsequently I have entered records directly in to the database.
I have several tables and layouts.
The imported data is correct but I now want to add data which originates in another table in the same database.
When I change the source of the data using the inspector (Display data from) the original records are blank because they do’t originate from the “new” source table.
If I remember correctly there is a way of copying and pasting records in table view that preserves the original (imported in this case) data and allows new data to be added from other (new) tales.
I can’t recall how this worked and would appreciate some help please.