Combine two field’s into a third field as a default value

[Frank]

Could you please help me with the following:
I have Table.V1 with a Primary key IDAutonumber [which generate a number for
example 8] and a second Tabel.K2 with a primary key IDAutonumber [which
generate a number for example 6] in Table.K2 there is also a field called
GRV. I want to combine Table.V1 [Primary key number with Table.K2 primary key
number to generate a number 8/9 automatically in the GRV field of Table.K2
Table.V1 refer to a product sellar [seller information]and Table.K2 refer to
products [product data] the GRV number that refer to the sellar and the
product sold
Kind regards
Appreciate your time and effort
Frank

 

[Stefan Hoffmann]

hi Frank,

I have Table.V1 with a Primary key IDAutonumber [which generate a number for
example 8] and a second Tabel.K2 with a primary key IDAutonumber [which
generate a number for example 6] in Table.K2 there is also a field called
GRV. I want to combine Table.V1 [Primary key number with Table.K2 primary key
number to generate a number 8/9 automatically in the GRV field of Table.K2

You don't need to store this information as you should be able to always
(re-)query it, e.g.

SELECT K2.ID & "/" & V1.ID
FROM V1
INNER K2
ON V1.ID = K2.idV1

Table.V1 refer to a product sellar [seller information]and Table.K2 refer to
products [product data] the GRV number that refer to the sellar and the
product sold

Can you post the exact table structure?


mfG
--> stefan <--

 

[De Jager]

Could you please help me with the following:
I have Table.V1 with a Primary key IDAutonumber [which generate a number
for
example 8] and a second Tabel.K2 with a primary key IDAutonumber [which
generate a number for example 6] in Table.K2 there is also a field called
GRV. I want to combine Table.V1 [Primary key number with Table.K2 primary
key
number to generate a number 8/9 automatically in the GRV field of Table.K2
Table.V1 refer to a product sellar [seller information]and Table.K2 refer
to
products [product data] the GRV number that refer to the sellar and the
product sold
Kind regards
Appreciate your time and effort
Frank