Hello
I am Very Very New Student For MS Access.I have a Problem in my Access Data base
I have Tables
1. BusStops
It has these fields.
In this table Have these fields
As a example i entered fare for between two bus top. as example StartBusStop = A, EndBusStop = B , Fare =120
3.Journey
Inhere I Created 3 fields.
1.Start
2.End
3.Amount
Then I created a form to add data to this table. In the form i use combo boxes for Start and End fields by using data of the BusStops Table. So now i want to auto generate Bus Fare when i select Start and End Bus Stops. Bus fare is already added to BusFare Table.
As a example what i need,
When i select in my form combo box
Start = A
End = b
I want to generate fare amount by using Busfare table automatically.
It's better to tell me simple way to do that
Thank You.
I am Very Very New Student For MS Access.I have a Problem in my Access Data base
I have Tables
1. BusStops
It has these fields.
- BusStopID
- BustopName
In this table Have these fields
- StartBusStop
- EndBustop
- Fare
3.Journey
Inhere I Created 3 fields.
1.Start
2.End
3.Amount
Then I created a form to add data to this table. In the form i use combo boxes for Start and End fields by using data of the BusStops Table. So now i want to auto generate Bus Fare when i select Start and End Bus Stops. Bus fare is already added to BusFare Table.
As a example what i need,
When i select in my form combo box
Start = A
End = b
I want to generate fare amount by using Busfare table automatically.
It's better to tell me simple way to do that
Thank You.