Following the advice to have all info on one table and use views, I have successfully created a one table base for my law library. For views separating case law and articles, for example, is easy. I have a field in which I enter a letter according to the subject. eg for cases, enter C, for articles enter A.
For a different project, I should also like to have a one table base, but am unable to work out how best to add records where each primary field record (the record in the primary field) and its different fields have numerous records in the same field.
For example:
Existing Setup:
2 tables. Table 1 and Table 2
In each table I have 3 fields including the primary field.
In Table 1, this primary field is renamed Property
Next field is Y, the next field is Z.
In Table 2, the primary field is Date.
Next field is Location, next field is Notes.
Location field is linked to Y in Table 1.
Add 5 records:
In Table I in Y
enter Lindon
enter Birmingham
In Table 2
Record 1
Primary field Date I enter date.
in field Location, I link to London (in table 1, Y)
In field Notes, I enter a note.
Record 2
Primary field Date I enter date.
in field Location, I link to Birmingham (in table 1, Y)
In field Notes, I enter a note.
Record 3
Primary field Date I enter date.
in field Location, I link to London (in table 1, Y)
In field Notes, I enter a note.
Record 4
Primary field Date I enter date.
in field Location, I link to London (in table 1, Y)
In field Notes, I enter a note.
Record 5
Primary field Date I enter date.
in field Location, I link to Birmingham (in table 1, Y)
In field Notes, I enter a note.
The two tables are now populated with the example.
Group to field Location and sorption date, I now see 3 records for London each with date and notes alongside; and 2 records for Birmingham (ditto).
Issue
I seems to me that two tables makes sense: I can group to Location and have all the entries for each record listed in date order with their notes alongside, AT advice is to have one table and use different views. So how would I achieve what having 2 tables would do?
The only thing I can think of is for Table 1 to contain (in addition to any other fields) two further fields, one for date, one for notes and for a view filtered accordingly.
Surely that would result in a lot of clutter in Table 1? If so then would that matter?
Or this is a case where having tables makes more sense?
In the same base, I have a table for contacts.
In the primary field I put the contact company or person.
In subsequent fields, tel, mobile, email, address, role, link to Table 1 field Location, etc.
If I were to put all the contact into Table 1 then the primary field in Table 1 (X) would contain the unique stuff regardless of topic, with numerous fields for everything else. Again would that matter?
tia
