One to Many Relationship Question

[SpiritedAway]

Hi

I have a question about table relationships - one to many.

[tblProject].[ProjectID] has a one to many relationship with [tblDocuments].[ProjectID]

[ProjectID] in [tblDocuments] has a lookup row source:
SELECT tblProjects.ProjectID, tblProjects.ProjectNumber FROM tblProjects ORDER BY tblProjects.ProjectNumber;

The combobox in [ProjectID] in [tblDocuments] displays 2 columns 1.[ProjectID] 2.[ProjectNumber]

When the user selects this field in a form - he wants the field to record -[ProjectNumber] (which includes numerical and text values) and not the [ProjectID] (he wants that row hidden as it might confuse the users) -

But as a one to many relationship is numerical - the field will only use a number and not text. Right?

But I'm sure I've seen a one to many table database - in which the user was able to select from the many table a text value where the id value was hidden.

Does anyone have any ideas if this is possible.

I'm using Access 2007

Thanks for your help!

 

[namliam]

Yeah, simply set the column width of the first column to 0, that way it wont be displayed in the combo though it will be stored....