Recent content by Joemully

Thanks for the suggestions - there are a few more constraints I didn't mention. The database will be used in Asian development context with poor internet connectivity i.e. a non-networked environment. In practice this means there will four independent databases that will have to combined into a...

Many thanks for the good advice. There are forty subdatasheets below this table (also using a few join tables). Rather than using a composite relationship on the LocationCode and SurveyNumber - I would rather have them combined in a single field to keep things simple for data entry. Any idea...

Hi - I've set up a simple database for some survey work. Data tables are linked by a primary key consisting of a 10 to 12 digit location code (picked up from a drop-down list) and a 2 digit survey number - all stored as text. Rather than use compound relationships I would like to combine these...