If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PLS HELP~! Simple Question: Master & Child Link without subform
Good day everyone.
I appreciate any suggestion by all of you. 1st Is possible have Master & Child Link function without adding any subform? If yes, how? Eg: When I selected a customer "ABC Inc" from a combolist (or many more than 1 field; eg this month,sales man A and etc), all transaction record from table tbltransaction will show me all transactions in a ~*SPLITFORM*~ according what i selected, when I adding new record in the form the table tbltransaction will automatic adding new record including all selection(customer ABC Inc,sales man A and etc) I make which like how parent form and subform do between master link and child link. I did not use subform for this because I unable to add Splitform in a subform, I search many place but cant found the best solution, I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can synchronize between single view subform and datasheet subform, but I facing problem when I adding new record and delete record and other few small problems. What I can say is not a new user can simply done this without a good VBA knowledge, as my problem is very simple so I hope I can mimic subform function in Splitform, so I do not need to write many VBA code for 2 subforms(1 single form and 1 datasheet) or maybe someone can teach me how to write the VBA code which allow me mimic splitform in 2 subform. I tried to solve and search solution in internet about 2 months, I really hope anyone can help me this new user to solve this simple problem. |
#2
|
|||
|
|||
PLS HELP~! Simple Question: Master & Child Link without subform
If I understand what you want I think if you Left Join Master to Child in the
query it will function like you want. -- Build a little, test a little. "Kaoli" wrote: Good day everyone. I appreciate any suggestion by all of you. 1st Is possible have Master & Child Link function without adding any subform? If yes, how? Eg: When I selected a customer "ABC Inc" from a combolist (or many more than 1 field; eg this month,sales man A and etc), all transaction record from table tbltransaction will show me all transactions in a ~*SPLITFORM*~ according what i selected, when I adding new record in the form the table tbltransaction will automatic adding new record including all selection(customer ABC Inc,sales man A and etc) I make which like how parent form and subform do between master link and child link. I did not use subform for this because I unable to add Splitform in a subform, I search many place but cant found the best solution, I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can synchronize between single view subform and datasheet subform, but I facing problem when I adding new record and delete record and other few small problems. What I can say is not a new user can simply done this without a good VBA knowledge, as my problem is very simple so I hope I can mimic subform function in Splitform, so I do not need to write many VBA code for 2 subforms(1 single form and 1 datasheet) or maybe someone can teach me how to write the VBA code which allow me mimic splitform in 2 subform. I tried to solve and search solution in internet about 2 months, I really hope anyone can help me this new user to solve this simple problem. |
#3
|
|||
|
|||
PLS HELP~! Simple Question: Master & Child Link without subfor
May I know what you mean left join Master to Child in the query?
"KARL DEWEY" wrote: If I understand what you want I think if you Left Join Master to Child in the query it will function like you want. -- Build a little, test a little. "Kaoli" wrote: Good day everyone. I appreciate any suggestion by all of you. 1st Is possible have Master & Child Link function without adding any subform? If yes, how? Eg: When I selected a customer "ABC Inc" from a combolist (or many more than 1 field; eg this month,sales man A and etc), all transaction record from table tbltransaction will show me all transactions in a ~*SPLITFORM*~ according what i selected, when I adding new record in the form the table tbltransaction will automatic adding new record including all selection(customer ABC Inc,sales man A and etc) I make which like how parent form and subform do between master link and child link. I did not use subform for this because I unable to add Splitform in a subform, I search many place but cant found the best solution, I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can synchronize between single view subform and datasheet subform, but I facing problem when I adding new record and delete record and other few small problems. What I can say is not a new user can simply done this without a good VBA knowledge, as my problem is very simple so I hope I can mimic subform function in Splitform, so I do not need to write many VBA code for 2 subforms(1 single form and 1 datasheet) or maybe someone can teach me how to write the VBA code which allow me mimic splitform in 2 subform. I tried to solve and search solution in internet about 2 months, I really hope anyone can help me this new user to solve this simple problem. |
#4
|
|||
|
|||
PLS HELP~! Simple Question: Master & Child Link without subfor
Kaoli wrote:
May I know what you mean left join Master to Child in the query? If I understand what you want I think if you Left Join Master to Child in the query it will function like you want. [quoted text clipped - 27 lines] I tried to solve and search solution in internet about 2 months, I really hope anyone can help me this new user to solve this simple problem. LEFT join means "include ALL records in the "Left side" table, and only matching records in the right side. So say you have the standard Customers and Invoices tables joined on CustomerID... SELECT Customer.CustName, Invoice.InvoiceNo FROM Customer LEFT JOIN Invoice ON Customer.CustomerID = Invoice.CustID will display ALL Customers regardless of whether they have any invoices, and any invoices they may have. An INNER join will eliminate all customers from the result set that have no Invoices. -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
PLS HELP~! Simple Question: Master & Child Link without subfor
In the underlying query
There should be a link between the two tables ( a line from customer id to customer id - or whatever you call the field identifying the customer). Double-click on the line and choose the option that shows all customers in the customer table and matching records in tblTransaction - option 2 or 3 depending on how the relationship was set up. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Kaoli wrote: May I know what you mean left join Master to Child in the query? "KARL DEWEY" wrote: If I understand what you want I think if you Left Join Master to Child in the query it will function like you want. -- Build a little, test a little. "Kaoli" wrote: Good day everyone. I appreciate any suggestion by all of you. 1st Is possible have Master & Child Link function without adding any subform? If yes, how? Eg: When I selected a customer "ABC Inc" from a combolist (or many more than 1 field; eg this month,sales man A and etc), all transaction record from table tbltransaction will show me all transactions in a ~*SPLITFORM*~ according what i selected, when I adding new record in the form the table tbltransaction will automatic adding new record including all selection(customer ABC Inc,sales man A and etc) I make which like how parent form and subform do between master link and child link. I did not use subform for this because I unable to add Splitform in a subform, I search many place but cant found the best solution, I try to mimic splitform in 2 subforms(1 single form and 1 datasheet), I can synchronize between single view subform and datasheet subform, but I facing problem when I adding new record and delete record and other few small problems. What I can say is not a new user can simply done this without a good VBA knowledge, as my problem is very simple so I hope I can mimic subform function in Splitform, so I do not need to write many VBA code for 2 subforms(1 single form and 1 datasheet) or maybe someone can teach me how to write the VBA code which allow me mimic splitform in 2 subform. I tried to solve and search solution in internet about 2 months, I really hope anyone can help me this new user to solve this simple problem. |
Thread Tools | |
Display Modes | |
|
|