Hi, hoping someone can give me some pointers on this. I am new to FM so please excuse if this is a very basic concept.. I'm on a steep learning curve here.
I am creating my database to track inventory of assets.
We have two types of assets, let's say they are Cars and Dairy Cows. Each have very different characteristics (fields), that I need to record.
For example, for a car, I would want to see make, model, year, mileage, type of engine, registration, how many doors, type of fuel, last service date, VIN no, service notes, purchase price, purchase date.
On the cow, I'd want breed, sex, tag, origin, pedigree, date of birth, dates of vaccinations, vet records, purchase price, purchase date, milk yield, breeding history...
so, SOME of the fields are the same (purchase price, purchase date), but some are not applicable to one or the other type of asset.
What is the best way to go about laying this out? Ideally I would like to see only the applicable fields for that type of asset when viewing the database and entering data.
Thanks for any pointers.