help in some calculations and searching

[Nokia N93]

Hi to all


Hope you are fine and in a good health

i need your help in this database
this small shop, when a customer come, we entered his data, he will come with maintenance , let us say he came 3 days ago, he make a maintenance of 100 $, but he paid only 40, so the remaining is 60, today he came to make another maintenance that cost 200, he paid only 100 (60 the remaining and 40 the new one) , so we want from him now 160.

how can i make a report showing all his transactions , SHOWING the Total money needed from him?

another thing i want to search for a specific customer to show all the previous transactions and to add a new one, how can i do this search ??
I tried to do a combo box, but it didn't retrieve the transactions in the subform

I tried to make it, but i think there is something wrong in it
attached is what i started to do

Can you please help me in that
Thanx in advance

[Cosmo Monkey]

I don't think your problem is your form not working, if your open up Maintence detail Subform as a seperate form you will find that your calculation are there. I believe you are having the same problem as me with figuring how to embed a form within a form. I am searching high and low. Jumping from branch to branch. I will mark this thread and if I find the answer before you due will post. If you find it before me please post your solution.
Cosmo
Still flinging

[June7]

Suggestions:

1. a combobox on Maintenance form to select customer for maintenance event, bind to CustID field from Maintenance

2. change the Maintenance form RecordSource from INNER join to:
SELECT Maintenance.*, Customer.CustID AS CustID_Customer, Customer.CustName, Customer.CustTel
FROM Customer RIGHT JOIN Maintenance ON Customer.CustID = Maintenance.CustID;

3. set textboxes displaying customer info from Customer table to Locked Yes, TabStop No

4. The expression TotalCost doesn't make sense if there are multiple records in Detail - the expression will only consider the subform current record.
Need the subform in continuous view, have a textbox in its footer to Sum the Remaining:
=Sum([Cost]-[Paid])
Now textbox on Maintenance: =[MaintenanceDetail Subform].[Form].[Total]

5. review http://datapigtechnologies.com/flash...mtoreport.html for one method of filtering form/report

[Nokia N93]

I don't think your problem is your form not working, if your open up Maintence detail Subform as a seperate form you will find that your calculation are there. I believe you are having the same problem as me with figuring how to embed a form within a form. I am searching high and low. Jumping from branch to branch. I will mark this thread and if I find the answer before you due will post. If you find it before me please post your solution.
Cosmo
Still flinging

yes this is totally our problem ,, im still searching , but it is not working out

[Nokia N93]

Suggestions:

1. a combobox on Maintenance form to select customer for maintenance event, bind to CustID field from Maintenance

2. change the Maintenance form RecordSource from INNER join to:
SELECT Maintenance.*, Customer.CustID AS CustID_Customer, Customer.CustName, Customer.CustTel
FROM Customer RIGHT JOIN Maintenance ON Customer.CustID = Maintenance.CustID;

3. set textboxes displaying customer info from Customer table to Locked Yes, TabStop No

4. The expression TotalCost doesn't make sense if there are multiple records in Detail - the expression will only consider the subform current record.
Need the subform in continuous view, have a textbox in its footer to Sum the Remaining:
=Sum([Cost]-[Paid])
Now textbox on Maintenance: =[MaintenanceDetail Subform].[Form].[Total]

5. review http://datapigtechnologies.com/flash...mtoreport.html for one method of filtering form/report

thanx for the help ,, the calculations are perfect, nothing wrong with it now ,, but when i tried to change the recordsource of the form , nothing showed in the form
i think i'm doing something wrong
i attached a new file , if you please tell me what to do,, i know i'm a little annoying
but thanks in advance for your help, and pardon me for any inconvenience

[June7]

Nothing shows because there are no records in tblOrder. There are records in tblOrderDetail but the OrderID field is empty. Odd, not allowing me to enter records in tblOrder.

[Nokia N93]

Nothing shows because there are no records in tblOrder. There are records in tblOrderDetail but the OrderID field is empty. Odd, not allowing me to enter records in tblOrder.

i know am an annoying person
but is the relationship in my Db is right >??
what i want is too search for a customer, showing me his personal info , and the previous orders, with the ability to enter new orders and to be saved ,, but it is not working for me

[June7]

The table designs are ok. I removed the relationships and then I was able to enter data into tblOrder, so yes, guess relationships are set wrong or somehow corrupted. Delete and reset.

The form opens with UNBOUND combobox showing customer ADAM because of DefaultValue property. I would not have default value set for an UNBOUND combobox used to input filter criteria. There is no code (VBA or macro) associated with the combobox. Review the link referenced in item 5 of earlier post for one method to filter form.

Need to show the OrderID and DateOrdered on the main form.