Associate
- Joined
- 21 May 2003
- Posts
- 1,008
Hi. I'm making a database for a property letting company and am having some trouble.
I've made a table called houses, and a table called flats. Each house can have upto five flats in it.
all i want to do is when i create a house, have a box there to say how many flats it has, and then write say 5 entries in the flats table pointing to one entry in the house table.
i know i can do this manually but i'd much rather have it automatically enter as many as it has.
any help is appreciated
I've made a table called houses, and a table called flats. Each house can have upto five flats in it.
all i want to do is when i create a house, have a box there to say how many flats it has, and then write say 5 entries in the flats table pointing to one entry in the house table.
i know i can do this manually but i'd much rather have it automatically enter as many as it has.
any help is appreciated