relationship linking row and coloumn in a table

[crpradu]

hi
i am making a database from which i can calculate fuel required from one point to other in any particular type of vehicle.
the problem is fuel from Pt A to Pt B is not same as from Pt B to Pt A.
A sample table is attached as zip.
View attachment qp.bmp
is there any way i can cross refer field values with that of rows .
thanks

 

[namliam]

simply make a table From - To - Feul
a - b - 10
b - a - 5
etc.

Should be easy to do?

 

[ButtonMoon]

I suggest you structure your table something like this:

From To Fuel
---- ---- ----
A B 10
A C 15
B A 5
B C 5
C A 10
C B 5

 

[crpradu]

hi guys
thanks for your reply..
i thought of it, but i have around 20 Pts which will make it along list . And adding a new pt/removing one is not easy. there are more chances of making a mistake.it is a network as in the following pic
View attachment network.bmp
i guess there is no other way out then???

 

[Galaxiom]

i thought of it, but i have around 20 Pts which will make it along list .

Long lists are not an issue for Access. It deals far better with long than wide lists.

Moreover that structure is how you store your data. You can configure it to look however you want in the data entry forms.

 

[ButtonMoon]

hi guys
i thought of it, but i have around 20 Pts which will make it along list . And adding a new pt/removing one is not easy. there are more chances of making a mistake.it is a network as in the following pic

20 points I guess would mean you need up to 760 rows. That's a very small table, not a long one. If updates need to be by human beings then you could make your user interface a grid like the one you originally posted. User interface design doesn't have to look the same as table design.

 

[namliam]

It may be a long-ish to make manually, which I can understand, but if you have the table in the format you linked earlier... You can easily semi-auto-generate the detail table from that either in excel or in access.

 

[Mihail]

I can't anticipate how the queries will be if you use a table like this:

From    To    FuelAB    FuelBA
 A       B      10       5

 

[Mihail]

You can leave blank (Null) the FuelBA field if FuelBA = FuelAB

 

[namliam]

Given the layout in the OP, it should be easy... assuming it is in digital format (in excel or something)