M
manish
Dear Jeff,
I apologize for not providing the right kind of
information earlier. I had also put this in the Tables
categories. so please pardon me.
Let me try again :-
I have three tables and there contents are as follows:
Advance Table Description of fields
------------ ---------------------
date date of payment
v-no Receipt voucher no.
name Name of person to whom advance is paid
Amount Amount of money paid
Adjustment table
----------------
date date of adjustment
v-no voucher no. against which adjusted
account head eg. Electricity, courier, Travelling
detail just minor details
amount amount adjusted
Now when a person is paid advance a voucher is prepared.
Later after 2 or 3 days when he spends money for official
purposes on say - Office Car fuel, Stationery, Courier
expenses, Travelling, Car Maintenance etc. he brings the
bills & invoices to get it adjusted against his advance.
this is done through the second table (Adjustment table)
Now i have made the second (Adjustment table) as the sub-
data sheet of Advance table and linked it through the
field v-no. Similarly i have made forms & its subform.
Now what i want is to have another table for details of
TRAVELLING EXPENSES.
although when a person gives the bills it will be adjusted
in the second table itself against the vr. no's and
entered under account-head as TRAVELLING EXPENSES. But for
travelling expenses we have to maintained a detailed
information such as ::
departure date
arrival date
place of travel
mode of travel - ie. by bus, car, train or air
Travel fare
Hotel Charges
Local conveyance - taxi etc.
Fooding charges
Other office expenses on tour
Now i want to arrange my form in such a way that when i
enter "TRAVELLING EXPENSES" in account head another form
or anything should popup so that i can enter the
information for that person and which will be linked to
the information in the Adjustment table
Can this be done??? and can it be linked in such a way
that the name and v-no come automatically in the TRAVEL
DETAILS table.
Sorry for such a long question. But please bare with
me..becaus i am stuck very badly and do not what to do.
Also because i do not know VBA programming.
Please advice.
Manish
I apologize for not providing the right kind of
information earlier. I had also put this in the Tables
categories. so please pardon me.
Let me try again :-
I have three tables and there contents are as follows:
Advance Table Description of fields
------------ ---------------------
date date of payment
v-no Receipt voucher no.
name Name of person to whom advance is paid
Amount Amount of money paid
Adjustment table
----------------
date date of adjustment
v-no voucher no. against which adjusted
account head eg. Electricity, courier, Travelling
detail just minor details
amount amount adjusted
Now when a person is paid advance a voucher is prepared.
Later after 2 or 3 days when he spends money for official
purposes on say - Office Car fuel, Stationery, Courier
expenses, Travelling, Car Maintenance etc. he brings the
bills & invoices to get it adjusted against his advance.
this is done through the second table (Adjustment table)
Now i have made the second (Adjustment table) as the sub-
data sheet of Advance table and linked it through the
field v-no. Similarly i have made forms & its subform.
Now what i want is to have another table for details of
TRAVELLING EXPENSES.
although when a person gives the bills it will be adjusted
in the second table itself against the vr. no's and
entered under account-head as TRAVELLING EXPENSES. But for
travelling expenses we have to maintained a detailed
information such as ::
departure date
arrival date
place of travel
mode of travel - ie. by bus, car, train or air
Travel fare
Hotel Charges
Local conveyance - taxi etc.
Fooding charges
Other office expenses on tour
Now i want to arrange my form in such a way that when i
enter "TRAVELLING EXPENSES" in account head another form
or anything should popup so that i can enter the
information for that person and which will be linked to
the information in the Adjustment table
Can this be done??? and can it be linked in such a way
that the name and v-no come automatically in the TRAVEL
DETAILS table.
Sorry for such a long question. But please bare with
me..becaus i am stuck very badly and do not what to do.
Also because i do not know VBA programming.
Please advice.
Manish