Hi,
Been away from access for a couple of years and have a new project, I am after a little help bump starting my brain.
I have the part numbers for all parts on a range of motorcycles and am looking for a simple example set-up to start from. I have seven types of motorcycle and thousands of parts which need to be applied to one or more of the different types. The idea is to enter a part and all it's details and reference it to all the types of motorcycle it fitted. For example I want to enter 32645 and all it's details (not an issue) and then relate it to the 1950 RE1, the 1952 RE2 and the 1955 RE2 but not to the 1957 EN, part number 45632 would have all it's details and relate to the 1952 RE2 and the 1957 EN et cetera.
Any help would be greatly appreciated.
Been away from access for a couple of years and have a new project, I am after a little help bump starting my brain.
I have the part numbers for all parts on a range of motorcycles and am looking for a simple example set-up to start from. I have seven types of motorcycle and thousands of parts which need to be applied to one or more of the different types. The idea is to enter a part and all it's details and reference it to all the types of motorcycle it fitted. For example I want to enter 32645 and all it's details (not an issue) and then relate it to the 1950 RE1, the 1952 RE2 and the 1955 RE2 but not to the 1957 EN, part number 45632 would have all it's details and relate to the 1952 RE2 and the 1957 EN et cetera.
Any help would be greatly appreciated.