How to create subrecords?

[silkyyy]

Hi I would like to have 2 tables, 1 containing all data entry ( which I currently have ) 2nd table showing past and present history on table 2 of the original most updated record I have in table 1.

Purpose ; to avoid duplicate data entry in table 1, just have specific information on table 2, and ALL information on table 1.



Any ideas?

I have 1 form connecting to the main table, second table has a relationship with the first table through PK...but I am stuck from here.

Thanks, any help is appreciated.

[orange]

What's the difference in these 2 tables?

Often you have something like:

-a table of verified/validated pure gold data , the company uses this for Production, and
- a table of questionable data, not yet validated, not yet checked against our Production data


The Production table will have primary keys to ensure unique records. No duplicates in Production data.

Where do your tables fit in this scenario?
What specific questions do you have ?

[silkyyy]

orange thanks for the reply.

My set up is like this : table 1 all data with executives name address phone etc...30 fields approx ( with the most updated conference location and date )

table 2 - i would like to have all the date changes the executive ever made to the same location ( so for example table 1 is - Conference location : LA Date : 6/1/2012 where table 2, gives me a history of reschedules for LA he ever did, from 4/30/2012 to 5/1/2012 5/27/2012 to latest date 6/1/2012

So the latest date is original record -

subrecords with past dates is in table 2.

Where do I make these updates in the table or form+subform ( subform I dont have yet ) only have a form connected to the main table.



Is it something in relationships I have to change?

[orange]

What do your tables represent in business terms eg Customer, LocationChanges??, Products, Orders, Hobbies....

You should do a little research on Normalization, and Entity Relationship Diagramming. These will help you with your data base tables and relationships.

see the first few topics at http://www.rogersaccesslibrary.com/forum/topic238.html

Also, read the article here on Database principles - it is attached to the post
http://forums.aspfree.com/microsoft-...es-208217.html


Good luck

[silkyyy]

orange thanks for your reply, i managed to establish a relationship how I wanted it. For example when I am typing a record in table 1, I get the ID pulldown PK, where I can type subrecords there. When I refresh I see all the records I typed in Table2 for that record 1 in my original table. However in Table1 when I am typing in new record for example record 2 and want to pulldown again to write my subrecords in to reflect Table2, I get this error " This expression is typed incorrectly or it is too complex to be evaluated " #Name?

Can you try this and see, for example type in a new city and the identifier PK pull down will appear