K
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 date. 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?
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 date. 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?