Hi,
One of those many days occurring frequently lately, when I just can't seem to think straight
I have 3 tables :
tblClients
tblDiscounts
Code:
DiscountID DiscountName
1 Off Season
2 Christmas
3 NewYear
4 Garage Sale
tblRecords
Code:
Client Date DiscountID DiscountPercent
I have a form, in which I enter the Date, Discount Percent & select the Clients to whom it is applicable, via a checkbox(perhaps):
_______________ Start of Form _____________________________
Date 12/21/2012
DiscountID DiscountName DiscountPercent
1 Off Season 10
2 Christmas 0
3 NewYear 20
4 Garage Sale 0
ClientID SELECT
A Yes
B
C
D Yes
E
F Yes
G
H Yes
I Yes
J
___________ End of Form _____________________________
How do I make the 3rd table
tblRecords
Code:
Client Date DiscountID DiscountPercent
get populated like below (order of records not important)
Code:
Client Date DiscountID DiscountPercent
A 12/21/2012 1 10
D 12/21/2012 1 10
F 12/21/2012 1 10
H 12/21/2012 1 10
I 12/21/2012 1 10
A 12/21/2012 3 20
D 12/21/2012 3 20
F 12/21/2012 3 20
H 12/21/2012 3 20
I 12/21/2012 3 20
Then, I should be able to go back to refreshed form & the form should not have the Clients who have been already entered in tblRecords for the date 12/21/2012, to do entry for the remaining Clients.
Thanks