Problems with General Customer form

[toskov via AccessMonster.com]

I want to combine information from two forms in third. What I mean - I have
customers who buy products and then returned some of them. The idea is when
the transaction is completed, to have generated the third form in which to
see the difference from the purchased and returned products. I use tables
called "Inventory Transactions", "Products", "Customers"

 

[Ryan]

I would do this in the queries, not in another table. Assuming all three of
your tables are linked, and that for each one Customer you can have multiple
Inventory Transactions, you could add a status field for each single product.
The status would show that the product was purchased or returned. The
easiest way would be to use a checkbox in your products table, and in the
query have a field that looks like this...

Status: IIf([CheckboxFieldName] =True,"Returned","Purchased")

You could also adjust the total amount of the transaction with another field
in your query that looks like this...

TotalTransactionAmount: IIf([Status] =
"Returned",([ProductCost]*-1),[ProductCost])

 

[toskov via AccessMonster.com]

Thank you very much Ryan,
that works, but only if there only one product.
I need to generate the result for all products

I would do this in the queries, not in another table. Assuming all three of
your tables are linked, and that for each one Customer you can have multiple
Inventory Transactions, you could add a status field for each single product.
The status would show that the product was purchased or returned. The
easiest way would be to use a checkbox in your products table, and in the
query have a field that looks like this...

Status: IIf([CheckboxFieldName] =True,"Returned","Purchased")

You could also adjust the total amount of the transaction with another field
in your query that looks like this...

TotalTransactionAmount: IIf([Status] =
"Returned",([ProductCost]*-1),[ProductCost])

I want to combine information from two forms in third. What I mean - I have
customers who buy products and then returned some of them. The idea is when
the transaction is completed, to have generated the third form in which to
see the difference from the purchased and returned products. I use tables
called "Inventory Transactions", "Products", "Customers"

 

[Ryan]

It will take some formating of your fields, but you want to make your subform
of your products be a continous form. That will show all products for that
transaction on one page. Check out this link on master/detail with continous
form.
http://www.blueclaw-db.com/access_continuous_form_subform.htm

Hope this helps.
--
Please remember to mark this post as answered if this solves your problem.

Thank you very much Ryan,
that works, but only if there only one product.
I need to generate the result for all products

I would do this in the queries, not in another table. Assuming all three of
your tables are linked, and that for each one Customer you can have multiple
Inventory Transactions, you could add a status field for each single product.
The status would show that the product was purchased or returned. The
easiest way would be to use a checkbox in your products table, and in the
query have a field that looks like this...

Status: IIf([CheckboxFieldName] =True,"Returned","Purchased")

You could also adjust the total amount of the transaction with another field
in your query that looks like this...

TotalTransactionAmount: IIf([Status] =
"Returned",([ProductCost]*-1),[ProductCost])

I want to combine information from two forms in third. What I mean - I have
customers who buy products and then returned some of them. The idea is when
the transaction is completed, to have generated the third form in which to
see the difference from the purchased and returned products. I use tables
called "Inventory Transactions", "Products", "Customers"

 

[toskov via AccessMonster.com]

you were absolutely right, thank you very much

It will take some formating of your fields, but you want to make your subform
of your products be a continous form. That will show all products for that
transaction on one page. Check out this link on master/detail with continous
form.
http://www.blueclaw-db.com/access_continuous_form_subform.htm

Hope this helps.

Thank you very much Ryan,
that works, but only if there only one product.

[quoted text clipped - 20 lines]

 

[Ryan]

No problem, please remember to mark this post as answered if this solves your
problem.

you were absolutely right, thank you very much

It will take some formating of your fields, but you want to make your subform
of your products be a continous form. That will show all products for that
transaction on one page. Check out this link on master/detail with continous
form.
http://www.blueclaw-db.com/access_continuous_form_subform.htm

Hope this helps.

Thank you very much Ryan,
that works, but only if there only one product.

[quoted text clipped - 20 lines]

see the difference from the purchased and returned products. I use tables
called "Inventory Transactions", "Products", "Customers"