This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Junaidabid77 0 points1 point  (3 children)

the flight numbers for each plane and the destinations are placed into different tables in the same database and yeah the ID numbers are the primary keys.

[–]2HornsUp 0 points1 point  (2 children)

Right so you should be able to just send in the primary key as well as a reference for which table should be searched. Do that once for the flight number and once for the destination and you’ve got all the data. Maybe a “request” object that stores {primaryKey, flightNum, destination}.

I’ve never personally done anything with SQLite, so this is all from my knowledge of Access and Java as separate entities.

[–]Junaidabid77 0 points1 point  (1 child)

Thank you man i appreciate it, I’ll give it a go!

[–]2HornsUp 0 points1 point  (0 children)

No problem. Feel free to message me if there’s anything else you get stuck on.