[AccessD] Table of Names

If I understand your question, you want to have a TypeID in the one table
(Maintbl).  In another table you would have the types with a TypeID as the
primary key.

You would set the record source to "SELECT TypeID,Type FROM Types;".  The
combo box would be bound to the TypeID field in the Maintbl table.

So, is that clear as mud now?

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Wednesday, April 27, 2005 3:18 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] Table of Names


I never could get this right, so hopefully someone can explain it to me so I
can understand how to set up a table of names.

 

This new database has names for contact, issued to, issued by, closed by,
released by. Anyway, I know you aren't supposed to set up tables for each
type of name (I think). The right way is to set some kind of field in the
table that tells you what kind of person it is (the contact, etc).

 

If you add a field to tbl_PermitNames (PermitNamesID, PermitName,) & Type? 

 

When you add a combo box on the form for entering/selecting the name, how
does it know what type to add it to?

 

As you can see I am so lost on this.

 

Virginia

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com