A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto complete a field with a value from another table



 
 
Thread Tools Display Modes
  #1  
Old October 25th, 2007, 11:34 AM posted to microsoft.public.access.tablesdbdesign
Adrian B
external usenet poster
 
Posts: 10
Default Auto complete a field with a value from another table

Hi

I've got two tables with a One-to-Many relationship. In the Many table there
is a column/field which I want to automatically update based on the PK of the
One table.

Is there a way that I can ask the field to check for the latest PK field in
the One table and insert it into itself every time a record is generated in
that table?

Thanks

Adrian
  #2  
Old October 25th, 2007, 12:57 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Auto complete a field with a value from another table

That's how the main-form/subform design is set up. When you add a new
record to the subform, the main-form's underlying table's PK is inserted in
the subform's underlying table's FK field.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Adrian B" wrote in message
...
Hi

I've got two tables with a One-to-Many relationship. In the Many table

there
is a column/field which I want to automatically update based on the PK of

the
One table.

Is there a way that I can ask the field to check for the latest PK field

in
the One table and insert it into itself every time a record is generated

in
that table?

Thanks

Adrian


  #3  
Old October 25th, 2007, 01:54 PM posted to microsoft.public.access.tablesdbdesign
Adrian B
external usenet poster
 
Posts: 10
Default Auto complete a field with a value from another table

Thanks for the response. I've looked further into the problem and it really
is that I can't have a relationship between the tables or the form system
won't Insert properly.

So I need to create a simulated FK field based on the most recent/last
inserted value into a field in a different table.

Thanks

Adrian



"Jeff Boyce" wrote:

That's how the main-form/subform design is set up. When you add a new
record to the subform, the main-form's underlying table's PK is inserted in
the subform's underlying table's FK field.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Adrian B" wrote in message
...
Hi

I've got two tables with a One-to-Many relationship. In the Many table

there
is a column/field which I want to automatically update based on the PK of

the
One table.

Is there a way that I can ask the field to check for the latest PK field

in
the One table and insert it into itself every time a record is generated

in
that table?

Thanks

Adrian



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.