sequential numbers upto number based on field value number

[green369]

HI

friends please help me i having a table in which customer id, customer first name, customer last name, address, phone number, zip code, no of houses he own (number type) fields are there,

i designed a form in which a combo box is there, based on the field value no.of houses he own combobox should be populated with values 1,2,3,4,5 (upto the number in the field) based on the customer.



can any one help me to sort this issue.

Please

thanks in advance

Green369

[Bob Fitz]

HI

friends please help me i having a table in which customer id, customer first name, customer last name, address, phone number, zip code, no of houses he own (number type) fields are there,

i designed a form in which a combo box is there, based on the field value no.of houses he own combobox should be populated with values 1,2,3,4,5 (upto the number in the field) based on the customer.

can any one help me to sort this issue.

Please

thanks in advance

Green369

Why do you need a combo box? Why not use a textbox to enter/show the number?

[June7]

Ditto. What purpose does this combobox serve?

A database with only one table? Where is table that stores data about all these houses?

[green369]

HI

june7

i am new to database design actually my concept is a owner will owns a house in which he is having rooms which can be offered to tenents on rent basis i want a form in which owner details has to be displayed and also room number of that owner house which was given on rent to the tenent .

on this basis i need can you help me to figure this out

thanks in advance

[June7]

You need to identify data entities and relationships. Better get this nailed down before even thinking about the interface design.

In addition to Houses table, need a table for Reservations. And since you said owner could have multiple houses, need a table for People. Then if there could be multiple rooms for rent in each house, a table for Rooms.

Have you studied any tutorials on database concepts? Or even Access functionality?

[Welshgasman]

Now crossposted
https://www.accessforums.net/showthread.php?t=86313

[mike60smart]

HI WGM

They are 2 different database's

[Welshgasman]

HI WGM

They are 2 different database's

So what Mike.?
If you have two different cars, do you have to ask how you put fuel in each one? The logic is the same?

[orange]

Here's a sample model that may offer some insight on tables and relationships needed to support your processes. Ignore the Integer(10) info, that's a default from the software I am using. I didn't shrink the graphic to hide the numbers. I did shrink the other entities.