Auto enter a field?
Is there a way to get a field to automatically display and add the current data from another related field in another table, as well as enter it?
MainTable::MainID is the the table and field that I'd like to use.
Lets say I'm on the second record of MainTable, and I need to add some data to a related record in another table. I'll call the other table 'RelatedTable'. In this table, I have a linked field called MainTableID, and I'd like MainTableID to automatically add the data from the MainID field I just came from.
Can this be done?