General question Acces Database Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Goodmorning,

I would like to have the most suitable solution for this particular problem

I have a tabel A with the following fields Mattercode, mattername, rtk,
date, amount and comments.

some mattercodes are detailed and are put in table B with the following
fields mattercode, mattername, date, amount, the linking field is mattercode
(which is a key field).

e.g.

2000111/ Theunissen-Info/2000114/400 €/payment Philippe Modeal (Table A)
2000111/Theunissen-Info/2000114/400 €/payment Philippe Modeal (is detailed
in an other tabel)
matter code/+100€ paid 01-01-005
matter code/+100€ paid 02-01-05
matter code/+200€ paid 03-01-05 (Table B)

Could you please tell me how I can organize this best in Access, I've been
thinking about subreports, tabcontrols ect...

Thank you in advance!

Halima
 
I don't understand. Table A and Table B contain many of the same fields.
This is not good database design.

Why would you not simply put all the records in table A? Some will have
comments, some won't. I don't see the point of having two tables here.
 
AH - I see. You are storing details about the item in table2.

This is a one-to-many scenario. You have it basically correct.

TblMain
---------
MatterCode
MatterName
Rtk

TblDetails
----------
Mattercode
MatterDate
Amount
Comments



Note - you should not name a field "date" as this is a reserved word. Also,
I'd use a more spcific table name as shown above.
 
Back
Top