I'm very new at databases and Access, so please be kind...
I have two tables, A and B (in a one to many relationship). I'm trying to create a form for entering data into table A, such that as fields in the record are filled in, an unbound text field will dynamically assemble and display information taken from table B.
If I just enter an expression into the text field's control source property, it doesn't seem to be able to work outside of table A.
Do I need to create a query to mediate between the form and table A and B?, and to create the text for the display field? And if so, will/can the text display field update dynamically as the data entry fields are filled in?
Do I need to learn VBA to do what I am looking for?
Any help would be very much appreciated!