Relatonships between forms!

[Kavy]

Hello all, any help is greatly accepted!

The background is, I am trying to make a database where the user only sees my user forms when he/she loads access. Its going to have many modules, but the first one is bascially a budget (which could be done in excel but I want to learn access!).

I have one very quick question - at the bottom

If you bear with me, here is my table - schema and below i will post my questions!

Job List
Job# (KEY)
Position
Location
Salary
Hourly Pay
Shift Style
Hours Per Day
Boss 1
Boss 2
Other Income
DO#
DO# (optional, RSPS)

Debts and Owing
DO# (KEY)
Translist #
Name
Amount (Total)
S. Date
E. Date
Notes
Amount Paid
Income/ EXP
Paid off?

Transactions
Trans# (KEY)
DO#
Translist #
Notes
Amount
Date

Possible Transact
Translist# (KEY)
Name
Expected?


So those are my tables. Now I was creating blank forms and using basically VBA to control all my data. I found I can create a form directly from my table, and it can sort and add recrords to the table much nicer then I had set up!

My problem is the reletonships, for example.

I add a job to the "job list" table. I need it to create a record in the debts and owing table to accoutn for this job and I cant get it to do that. I tried setting a reletonship and no luck!

Any tips?


Thanks again for anything!

 

[huh?]

See <a href="http://www.mrexcel.com/forum/showthread.php?t=321738&highlight=create+form+modify+table+time+work">here</a> and see <a href="http://www.mrexcel.com/forum/showthread.php?t=323671&highlight=create+form+modify+table+time+work">here</a>.

Hope this helps.

 

[Kavy]

Thank you