Having searched on here and google for a few hours now, I have given in to posting my question here as this Access dummy is still struggling! I found one post similar here, but the anwser didn't help me.
I am trying to create a db so simple that even I could do it; but oh no! The db consists of two tables: one to hold my clients basic standard info (name, address etc) "form 1" and another to hold the data from each time we meet "form 2". I understand this is called 'one to many' relationship?? (i.e. I may see the client many times and so in form 2, need multiple records)
What I am trying to do is create a button on "form 1", that will open a fresh record in "form 2", but will 'carry over' some of the basic info (client ID and name). The only button I have managed to create is one that opens a new record in 'form 1' !!
Hopefully then when this form 2 is completed and the record saved, it will be linked to the original form 1.
- How to create such a button
- Is there a template for such a db? (all the ones I have found are far too much of an overkill and too complex!)
click the form you want to open [form 2]
open the form and find specific data to display.
click feild on right and left then <-> **
** base on the Jion it will open the form2 only sowing data base on form 1
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.