Search results

ok but will it matter if my primary key is an auto number linking to the textbox???

"Then place a textbox on the main form and set the Control Source to: =subformcontrolname.Form.keyfieldname The textbox should then track the current record in the subform." Does it matter if this textbox tracks my auto-number primary key ID?? because im not sure if this is the same as...

Sorry but i do not fully understand what you are trying to explain. Can you use my tables as an example? I know i must establish relationships but im not sure whats linkmasterfields. I want the borrower subform to refer to the main form and i want the sub-subform to refer to the borrower...

I want to do a form that has a main-form,sub-form and a subsub-form. Im using 3 tables: BorrowerCase,IndividualBorrower,Contact Party BorrowerCase has a one to many relationship with individualborrower and individualborrower has one to many relationship with contactparty. Each of these...

Alright ill take note although for this problem i havent even created relationships yet because i the problem i have is related to one table( I think...) although i think i already found a solution but i have not tried it yet

hello, I really need some help in a problem im facing right now which has made me frustrated. Please take a look at the attached pic which shows my latest form design. Right now i have unwanted duplicate fields in my form which is the borrower's name. In my case, for each borrower that the...

Whats a mexican favourite sport? Cross-Country

yes i created a switchboard to go to different forms based on related tables. However can i do it a different way as im not so sure about sub-forms. Is it possible to have an option box on each of the forms to choose the borrower ID and then add in the data which would be tied to this ID? P.s...

Hi thanks for replying, I have made sure not to use spaces in the table/field so i guess thats fine. About the information, tbh i am not sure about the process/data as i'm an intern in my office so im not familiarise with it yet but im suppose to build a database.What i can tell you is that...

Hi people, I have been pondering over this matter for awhile and i still cant find a solution so i hope they you all have one. So i am new to access and i have done some self studying on my own about design basic and normalisation(although i wont following this strictly due to the nature of...