Super Important Database Question!

[mwiley2011]

Hi all,


I'm working on a database for a college of business, which will eventually run their entire scholarship process. I'm to the point where I need to do certain things, but I'm not sure how...

Anywho, my first question.

I have a table in which I will have a field, Number_of_Guests. Is it possible to make the table add a certain number of lines for Guest_Names, depending on the number entered into Number_of_Guests? Like if I typed "3" in Number_of_Guests, the table would create 3 kind-of drop down blanks for me to type each individual guest's name into?

Thanks a ton!

[orange]

No. Do not repeat a field in a table. Create a new table and have a record for each guest. You will also need a FK to the original table.

Before getting too far into the "innards" of Access, do some research on Database design and Normalization.
Here's a link to get you started

http://forums.aspfree.com/microsoft-...es-208217.html

There are also some free videos on youtube.

[mwiley2011]

I'm relatively familiar with the "basics" of Access..
Is there an easier way to do this? This database needs to be user-friendly even to people not familiar with Access, so I don't want them to have to go to a different table to enter data every year for every guest.. as the guests will rarely repeat year after year.

[RayMilhon]

Create a Data Entry Form. Have the user's enter the data there. It's essentially a main form with your primary data and a Sub-form to enter the guest information.

[orange]

Well, you haven't provided much info about your intended application

a database for a college of business, which will eventually run their entire scholarship process. I'm to the point where I need to do certain things, but I'm not sure how...

Perhaps you could list the things you need to do, but are unsure how.

I don't think anyone here would have guessed that this would have been your first, and most important question
Is it possible to make the table add a certain number of lines for Guest_Names, depending on the number entered into Number_of_Guests?

My suggestion is to identify the things/entities involved and how they are related within the scope of your "business".

We are here to help and advise based on what you tell us. So help us help you by describing what it is you are trying to do, what you have tried and what specific issues you have encountered.

In any event,good luck with your project.

[mwiley2011]

I apologize, I didn't think you needed to know that much to answer my immediate question. As for the other things that I need done, I will post about them when I get to them.. I'm a student so my hours are limited at work, so it's one thing at a time here. I will also provide more information about the application..