HELP! Access Basics

[chrisguk]

Its been a while since I was creating access databases and I assure you I am very frustrated because I was able to create real complex solutions.

I seem to have forgotten the most fundamental aspects of creating a database for some reason and hope someone can help me.

My tables:

tablename: tblsite
FIELDS:

site id  - text   [primary key]
contract number - number
address 1 - text
address 2 - text
address 3 - text
phone - text

tablename: tblquery
FIELDS:

query no - autonumber
site id - text
query detail - memo
date - date/time

In the relationships window I link site id from tblsite to site id in tblquery as one to many.

NOw I want to create a form for tblsite. I so this using simple form wizard. I do the same for tblquery.

NOw I add a button to frmtblsite to open frmtblquery and to display specific records, matching the site code field from each table in the button wizard dialog.

The end result should be click the button and you can add or edit an entry that matches the record in tblsite and then create as many queries as you want for that site.

But its not doing it. The site id in the frmtblquery is not automatically populated. What am I doing wrong??

Any help is appreciated.

 

[Adam Caramon]

But its not doing it. The site id in the frmtblquery is not automatically populated. What am I doing wrong??

A lot of things .

But seriously, I'd never recommend having a primary key that is a text field. Also, making a table named tblquery is not a good idea. You'll just end up confusing yourself (and others).

And, there's a lot more. I strongly suggest looking for a beginner's tutorial on Access. I'm sure there's one or a thousand floating around the internet.

 

[chrisguk]

Hi,

Thanks for the reply.

I have spent some time looking tutorials and still cant figure out what I have done. If you were able to post some quick tips based on my example that would be helpful.

Thanks

 

[jdraw]

Here's a great intro.

http://www.allenbrowne.com/casu-22.html

Good luck