allow multiple vehicles per member
As a car club we want to record what cars a member has. Many members have multiple cars. We can create multiple fields such as Car1, Car2 etc but how many? Car10?Car20?. A better solution is to build a relational database link between the member file and the car file with an "Add Car" button to add an extra row in the Car file linked to the Member ID. This is easy to do in MS Access but I can no similar functionality here. Yet just about every car club has the same problem.