By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

How Many Tables Would you Recomend?

P: 3
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!
Nov 27 '08 #1
Share this Question
Share on Google+
1 Reply

P: 5

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,

Nov 27 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.