I would use two tables related by part number. The table for "Make" would contain fields for: part number calculation, beginning year, ending year, make, and model. Each field would have a pop-up list of previously used choices.
In a portal on the parts layout, it would show those various fields.
Thank you for your quick response.
I think I understand what you're saying. But what do you mean by a field for "part number calculation"? What is the calculation you're referring to?
And when you say "pop-up list" you mean a list with pre-populated values, where I can select multiple values at once?
What I don't understand is ... if the Portal will show the various fields in proper sequence, how will it know which values (ie. make, model, beginning year, etc.) go together? How will it know to layout the values correctly so that it shows, for example, "1987-2000 Chevy Tahoe" and not something else?
When I mentioned a field for part number calculation I was referring to the creation of a new portal record which would have an auto calculation for part number that would serve as the needed relationship.
The pop-up list would be used for the various fields where you would select one choice based on previously entered values for that field rather than a set list. Example: for the beginning year the first time you create a record there would be nothing in the pop-up list. You type in 2000 for that record. The next record you type in would should 2000 as a choice and not wanting that year, you would type in 2003. Third new record would give you 2 choices, and so on.
On second thought concerning model names, you should be using another related table. Look up Conditional Value Lists for that one.
You should be then be formatting the portal showing 3 fields from the make table and one from the new model table ... Make::Beginning Year then Make::Ending Year then Make::Name and finally Model::ModelName.
Read up on Conditional Value List and it may become clearer to you how to structure this.
I'll do some reading up on Conditional Value List as you suggest.
Thanks again for your input.