neilsolaris
Member
- Local time
- Today, 21:51
- Joined
- Apr 19, 2020
- Messages
- 114
Many thanks Minty, that works perfectly now!In your Payment combo change the row source to
SELECT [T-PaymentTypes].PaymentTypeID_PK, [T-PaymentTypes].PaymentType FROM [T-PaymentTypes] ORDER BY [T-PaymentTypes].Order;
Also change the Control source to PaymentTypeID_FK.
To do that you'll need to bring it in to the forms underlying recordsource;
Code:SELECT T_Payments.Musician_FK, T_Payments.EngagementsText_FK, T_Payments.DtPayment, T_Payments.Amount, T_Payments.VATReg, T_Payments.Notes, T_Payments.PaymentID, T_Payments.PaymentTypeID_FK FROM T_Payments;
The rest is as per the other combo's
In order to get the form to my proper database, can I just import it somehow? I'll have a look, maybe it's self explanatory. Otherwise, by describing how to do it with words was actually very useful! Thanks again.
Edit: I figured out how to import it now. Many thanks.