DAO (Database Access Object is probably the wrong term but trying my best to explain). I need my db to be as dynamic as possible. I created a dLookup in a form referencing a table called tBills. I have just changed the name of the table to tBills2 & it seems that references in the expression editor are not dynamic. I know this is the case in VBA also. What do I need to be aware of the common pitfalls in db design?
It is a text box coloured yellow. I imagine if had used the wizard it would be dynamic. But I'm trying to learn properly how it truly works. What would be the best way to enter a text box fed from another table so it is fully dynamic? I know I could use VBA but I want to keep VBA to a minimum as it seems that surely VBA is not required for this.
Also I can't see the source properly. With lots of tables... similar fields can get confusing. The record source only shows the field; how do you find out the source table? Take 2nd pic e.g. showing MainHeaderID I cannot see the table source? Disregard the fMainHeaders at the top because this could be renamed/ deleted.