Microsoft Access Database Question:
Explain about relationships and look up fields?
Answer:
Relationships are imported from the source to destination without any hindrance but once they land in the destination they can never be altered or changed and change of extensions cannot be of much help.
Lookup fields: -Make sure that you link tables, links, etc if you want to display look up values and not look up ids. Related table should be linked to the destination field for display of lookup values.
Lookup fields: -Make sure that you link tables, links, etc if you want to display look up values and not look up ids. Related table should be linked to the destination field for display of lookup values.
| Previous Question | Next Question |
| How can I open an MS Access database that has been converted to a current version? | How do you create an append query? |