[SOLVED] Two tables but multiple for one users

[Fetchitnow]

Hello Everyone.

 

I hope my explaination of my problem will be understood but if not just let me know.

 

I have a member table that has a unique key (eg member ID). However for each member they are able to add their vehicles to it and a registration number. What I need to achieve is the following, see example below:

 

Member 123 has 3 (upto 100+) vehicles. Each vehicle needs to be added to the "vehicles table" with the registration number and type eg small van, medium van etc etc

 

Ideally if they have not added any vehicles it will only show a blank field for them to complete the registration number and van type, if they have one or more vehicles it will show those but with a button facility to remove a record.

 

I think (correct me if you think I am wrong) that it might be best to add this as a function as the rest of the form can be submitted separatley.

 

Let me know if there is anything else you need.

 

Kind regards

 

Gavin

 

 

[RichardRotterdam]

Sounds like a basic CRUD app but what is your question?

[Fetchitnow]

The question was really which way to go about it. However after more thinking I have come up with a different work around which will work and will be easier to up grade in the future. I do have a problem with it but it is not related to the above so will put in another post in the correct catagory.

 

Thanks for getting back though. It is appriciated.