Hi there.
I'm pretty good with Excel, but I'm a relative newbie when it comes to Access!
I'm in a band and I'm responsible for sorting out the payments to the band members. I've been using an Excel spreadsheet to calculate what's due, but I'm trying to transfer the process to Access.
Where I'm stuck, and it may not even be possible, is this...
I have the main table called Gigs in which all the calculations are done. No problem with creating expressions - pretty much similar to Excel. The relevant field names to my problem are: Date, Venue, Fee, Mileage Member 1, Mileage Member 2 and Mileage Member 3.
I also have a table (with a form to input the data) called Venues, in which I have the field names Venue, Mileage Member 1, Mileage Member 2 and Mileage Member 3.
What I'd like to be able to do is create a form to input data to Gigs where all I have to input is Date, Venue (from a combo box linked to the Venues table) and Fee, but then have the mileages for each member and for each gig automatically input using the data in the Venues table.
I've tried all kinds of things - I assumed that using lookup would solve it - but I've had zero success.
Can this be done or am I wasting my time?
I'm pretty good with Excel, but I'm a relative newbie when it comes to Access!
I'm in a band and I'm responsible for sorting out the payments to the band members. I've been using an Excel spreadsheet to calculate what's due, but I'm trying to transfer the process to Access.
Where I'm stuck, and it may not even be possible, is this...
I have the main table called Gigs in which all the calculations are done. No problem with creating expressions - pretty much similar to Excel. The relevant field names to my problem are: Date, Venue, Fee, Mileage Member 1, Mileage Member 2 and Mileage Member 3.
I also have a table (with a form to input the data) called Venues, in which I have the field names Venue, Mileage Member 1, Mileage Member 2 and Mileage Member 3.
What I'd like to be able to do is create a form to input data to Gigs where all I have to input is Date, Venue (from a combo box linked to the Venues table) and Fee, but then have the mileages for each member and for each gig automatically input using the data in the Venues table.
I've tried all kinds of things - I assumed that using lookup would solve it - but I've had zero success.
Can this be done or am I wasting my time?