New to access Create Table

[yschuerm]

Hi,

I have got 2 tables and how can I fill one table with values from the other.

Table 1 :

ArtNR
ArtDescription
Source (to be filled with sourcedescription from table 2)


Table 2 :
SourcePK
SourceDescription


What type of field does Table1.Source need to be (it needs to contain table2.SourceDescription, but I think I need to compare it to table2.sourcePK to get it filled)
Table1 data will be filled as a bulk import and from then on using a userform.


I have excel and vba experience, but access has just been to long since I used it.
Thanks in advance

 

[ChrisM]

It needs to be the same type of field that table2.SourceDescription is, which I assume is Text.

Your task can't be completed with the fields you have available, because you have not created a relationship between ArtNR and any type of Source. For this to work, your Table 1 should have a field for SourcePK right now, before you even started working on this current question.

Is there another table that relates ArtNR to SourcePK somewhere?

 

[Micron]

yschuerm, I suspect you are quite familiar with spreadsheets, but they are nothing like database tables in spite of their appearance. ChrisM uses the words "relationships" and "relates" for a good reason. "it needs to contain table2.SourceDescription" - actually, it should not.
I get the impression that you really should research "relational database" for some primers on how to set up your tables (no disrespect intended).