calculate field

[dmc]

hi
i have 3 tables (jb;jb_ver;jb_vd)
jb_vd= jb_id&"."&jb_ver
all are primary keys
when i'm using a form i want jb_vd to be calculated automaticlly .
even when changing any of the used fields

 

[Jeff Boyce]

How is this a .forms newsgroup question?

How can a "table" be a "primary key"?

If you want a third table to have a primary key that consists of two fields
(e.g., foreign keys from two other tables), you can have multiple fields as
a primary key.

Don't bother inserting that "." or "calculating" a primary key. Just set
the two fields as a combined primary key.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


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