Hi,
I have a number of tables with the same structure they are all lookup tables. I went this way because I couldn't stop invalid data from being loaded (data is imported via transferspreadsheet). Even though I have set up validation in the spreadsheet, I wanted to make sure that if that gets beaten, that the database validation will stop the invalid data.
Could someone tell me the best way to do this using the single table approach? I do have combo boxes set up for the fields (and other validations), but was able to load invalid data with all of these set.
My alternative approach has been to set up a form with a combo box containing all of the lookup tablenames. I thought that I would just have a after update event which sets the form recordsource to the value in the drop-down list. This kind of worked, but in this form, I have two views of the same table - a single form with a datasheet version below it. (Overkill, but I am only allowing edits appends etc to the single form view - that datasheet view is there for quick view.)
The datasheet only shows a single record (the same as that in the single form). I have checked that there are no filters or parent/child relationships, and tried the me.requery, but can't see what else could be going wrong. Any suggestions?
Thanks,
Jason