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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatic number combination



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2010, 10:59 AM posted to microsoft.public.access
Frank
external usenet poster
 
Posts: 551
Default Automatic number combination


I have Table 1 with Field IDTable1 [autonumber] [and other fields] and Table
2 with Field IDTable2 [autonumber] and Field GRV set to text [and other
Fields]
Is the following posibble:
Can I automatically generate a number that can be used in GRV field of Table
2 consisting out of a combination of IDTable1 and IDTable2 written as
IDTable1/IDTable2 in the GV field of Table 2

I want this GRV number as a unique number identifying Table 1 and Table 2

Thanks for the help

  #2  
Old May 13th, 2010, 02:06 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Automatic number combination

You can, but shouldn't. All data in a table must identify the key. Foreign
Keys, which are the keys from IDTable1 (in Table2) should be a separate
field in table 2, and no field should be combined.

Using Access's built in subform system, you automatically generate the
linking value when you create the subform record.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Frank" wrote in message
...

I have Table 1 with Field IDTable1 [autonumber] [and other fields] and
Table
2 with Field IDTable2 [autonumber] and Field GRV set to text [and other
Fields]
Is the following posibble:
Can I automatically generate a number that can be used in GRV field of
Table
2 consisting out of a combination of IDTable1 and IDTable2 written as
IDTable1/IDTable2 in the GV field of Table 2

I want this GRV number as a unique number identifying Table 1 and Table 2

Thanks for the help



  #3  
Old May 28th, 2010, 03:59 PM posted to microsoft.public.access
Frank
external usenet poster
 
Posts: 551
Default Automatic number combination

Thanks Arvin

We want to use the combination of teh two autonumbers in the two takles as a
numbercombination to identiify the user [table1] and a item [table2] as
unique to that user and item for futher reference
I will remember your inpur in developing a new database

Thnak for your time

Frank

"Arvin Meyer [MVP]" wrote:

You can, but shouldn't. All data in a table must identify the key. Foreign
Keys, which are the keys from IDTable1 (in Table2) should be a separate
field in table 2, and no field should be combined.

Using Access's built in subform system, you automatically generate the
linking value when you create the subform record.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Frank" wrote in message
...

I have Table 1 with Field IDTable1 [autonumber] [and other fields] and
Table
2 with Field IDTable2 [autonumber] and Field GRV set to text [and other
Fields]
Is the following posibble:
Can I automatically generate a number that can be used in GRV field of
Table
2 consisting out of a combination of IDTable1 and IDTable2 written as
IDTable1/IDTable2 in the GV field of Table 2

I want this GRV number as a unique number identifying Table 1 and Table 2

Thanks for the help



.

 




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:51 AM.


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