Auto populate fields

Question

I have a master file and a transaction file. I want to automatically populate several fields in the transaction file from fields in the master file. For example, if the master file was an invoice file and the transaction table is the invoice items. I would like to automatically populate the invoice items with the invoice number and the invoice date. Any suggestion in how to do this?

I am using the Access 365 Web App. I am adding the items from a List view of the invoice table. The items are displayed in a tab below the invoice record and I add items by clicking on "add items." This brings up a list view of the item table. The invoice number is displayed ok, because I have used it in the "related field." But I would also like to populate another field from the invoice table. Is this possible?

Answer 1

Hi. I think you can use macros to do this, but it's usually not necessary to store the same information in multiple tables. It's against "normalization" rules to do so. Just my 2 cents...

Answer 2

Totally agree about normalization. Just want a visual indicator for the data entry person.

Answer 3

I understand. As I said though, you could try using macros. Unfortunately, I don't have any examples for you. If I find out anything, I'll let you know. Good luck with your project.