Data in subform

[Kelvin Lee]

I have a REGISTRATION_DETAILS table and forms. In that table I have NAME,
COUNTRY and etc...

In the forms, I want to have a subform to input Guest which may more than 1
guest. So how can I do this so that I can get a report which can see who
(register) will bring who (guest). Like:

NAME | GUEST
KELVIN | CELINE
KELVIN | JENNY
KELVIN | LILY
STEVEN | GEORGE
WILL | JOHN

Sorry for my poor English

Please help and thanks~

 

[Tom Wickerath]

Hi Kelvin,

My, you're quite the ladies man....bringing three female guests to your
party! Hope they don't get in a cat fight with one another

You will need a separate table for recording guests. You need to set up a
one-to-many (abbreviated 1:M) relationship, and you should include the
Enforce Referential Integrity option, so that you don't have uninvited guests
crashing your party (at least in your database, that is).

You should read up on database design some first. Make sure to read the
first two papers at this link, written by database design expert Michael
Hernandez:

http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

Also, NAME is considered a reserved word. You should avoid using any
reserved words for things that you assign a name to within Access. This
includes fields in tables, table names, queries, forms, reports, macros,
modules and controls in forms and reports.

Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html

So, start with the proper database design before attempting to go further
with any forms and reports.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Kelvin Lee]

Hi Tom,

Yeoh~ Just a sample, need no take so serious with the girls name~ Hahahah~

Well, I'm very new to use MS Access. Can you show me an example how to do
it? or can I have your e-mail so that I can print screen for my project for
your easy reference?

Many many thanks~

Kelvin

 

[Tom Wickerath]

Hi Kelvin,

Don't worry....I wasn't taking it seriously. Just having a little fun with
you.

Well, I'm very new to use MS Access. Can you show me an example how to do
it?

Search your hard drive for the sample database named Northwind.mdb. Or,
click on Help | Sample Databases | Northwind Sample Database:

http://support.microsoft.com/kb/824265

If you cannot find it, then it should be on your installation CD, or here is
a link to download the version that ships with Access 2000:

http://www.microsoft.com/downloads/...72-8DBE-422B-8676-C632D66C529C&displaylang=EN

Once you have Northwind open, click on Tools | Relationships, to view the
Relationships diagram. Notice, for example, how the Customers table is
related to the Orders table (A Customer can place many orders, so this is a
one-to-many [1:M] relationship). You need to set up something similar, with a
many-side Guests table.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________