PLS HELP~! Simple Question: Master & Child Link without subform

[Kaoli]

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.

 

[KARL DEWEY]

If I understand what you want I think if you Left Join Master to Child in the
query it will function like you want.

 

[Kaoli]

May I know what you mean left join Master to Child in the query?

 

[PieterLinden via AccessMonster.com]

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]

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.

 

[John Spencer]

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