How Many Tables Would you Recomend?

[Tonie]

this is my current layout. 4 tables each with difrent inputs

table 1-- Own Form.
table 2-- Own Form.
table 3-- Own Form.
table 4-- Own Form.

then i want to link the user to property each user can have many property/Houses what would be the best way to go about this ? what i was thinking to do is create a table for each property but then if in the future i need to add let's say 37 houses to one client i must add more property tables the same with each bond there can be 5 bonds on one house i finished everything els in the form inputs work etc but now i am stuck on these 2 fields.

1 Property Table Has 16 Fields so in other words if i must have 37 propertys i must create 37 propery tables each with 16 fields.
1 Bond have 4 same with bonds.

Then i want it the Show the total number of bonds for a client with the total $ amount on the form after i inputed all the propertys/bonds for that one client.

This post is related to my post earlier.

Please help this is the only thing that's keeping me back :/ was also thinking of makeing pages for each property but same problem if in future i need more property or an existing client buys one more on he's name i need to add more pages. :/ there must be a better way .

Any help Would be Awsome!

[dmne05974]

Tonie,

I would use only two tables given the situation you are describing if i am reading right. One table would store the customers each with an individual ID. A second table storing all the properties with an extra field 'customer ID' tied to the first table with a one to many relationship.

Hope this Helps,

dmne05974