I didn’t realize I could do this, but it makes sense with the relationships I setup. I’ve linked the master fields in the main form “PaymentID” and “BankID” with the slave fields “PaymentID” and “NameID”. I need to filter and display all Names in the subform that have a BankID from the main form.ĮDIT 2: The q_Name query was a dead end, but I’ve made some progress. I know this table/query is the key to my problem but haven’t yet figured out how to use it in my form. Maybe my subform should be a query instead of a table? Any help greatly appreciated.Įdit: I’ve made a query q_Name that is the same as tbl_Name only sorted first by BankID (ascending) and then by Name (ascending). What I can’t figure out is how to get the subform to give me a list of ‘tbl_Name.Name’ filtered to the BankID (and in place of tbl_TermPayment.NameID) in the main form. I have then added a list box to the main form (tbl_StandingOrder) that gives me the BankRef field and fills in the BankID field in the form. I have used the form wizard to set up a form for the tbl_StandingOrder that has a subform of tbl_TermPayment. My problem is designing a form to allow me to easily input the payment data. I have set up relationships between the tables as appropriate. The first field in the first three tables are auto incrementing primary keys, the last table uses PaymentID and NameID as its primary key.
(This is a scout group so siblings are possible). Club members pay monthly and some payments will cover more than one member. Once a month I get a statement with all the payments made that month.
I am setting up a database to track payments made by club members in a bank account. I am new to Base and database’s in general.
0 kommentar(er)
