You have two basic options here. Both work it's almost a preference choice on your part.
- Put all the fields in one table and just leave non-applicable fields empty.
- Put your data in three tables, A master table where you have one record for every cow and every car and you define fields here that apply to both cars and cows. Two "detail" tables--one for cows and one for cars that have specific to type fields and link to the master table with a one to one relationship.
With either approach, you can set up separate layouts for viewing cow and car records. Both Layouts would refer to the same table (this would be the master table if you use option 2) but would then be customized to the needs of that type of item.
You can use scripts and script triggers to make sure that each record is viewed/edited from the correct layout.
The main difference I can think of, is that if you need a report that lists detailed information on both cows and cars, option 1 may work a little better.
Thanks - I think option 1 sounds like it will be a little simpler.
Just to clarify what you said about setting up separate layouts for car/cow records; so would I set up a separate data entry layout for each type of record?
Exactly, and you just leave the fields that don't apply to that type of item off that layout.
OK thanks.. I'm sure I'll have more questions but I'll take a run at it. tks!