Help me create my First Tables and Relationship in Access

[Myproblem]

i am preety new in Access but and i have some task to do which is preety simple, but hard to me - to create simple table

here is the problem
I have to create table with some fields for each month: Account (Text is format, but it is acctually number), Account_Name (Text), Amount (Number), Date (Date). I know how to create this table.
Account in this table is unique.

I have to create an another table with fields: IFRS (text is format, but it is acctually number), IFRS_Name, and all the fields same as in first table [Account (Text is format, but it is acctually number), Account_Name (Text), Amount (Number), Date (Date)]. IFRS and IFRS_Name are unique in this table.

What I need is to put,make relationship in the way that Data field Account belonge to field IFRS from first table.

My task is very simple: to make query in the way in which you can make querry for certain date, or dates for IFRS.

I am loosing my mind making two different tables and trying to make adequate relationship, but i get error messages.

thx

 

[DMAC_the_fool]

What error message are you getting?

 

[Myproblem]

i think the problem is with Join Properties. I do not know how to assign certain Account in Account table to Account in IFRS table.

and after that make query bassed on IFRS and Account table, but with data from Account table for accounts, amounts and data

 

[Myproblem]

any other ideas, please?

 

[obiron]

your IFRS table does not need all of the additional fields from the Account Table, only the Account Number. This is the nature of a Relational Database.

There is a relation (Account Number) between IFRS and Account. If you know the IFRS record, you know the Account details because you can get them from the related Account record.

Your select statement would then look like this:

SELECT 
    A.*,
    I.* 
FROM 
    Account A 
  JOIN 
    IFRS I on A.Account = I.Account
WHERE
    A.Account = "012345"