Member Avatar for mitsuevo
mitsuevo 0 Newbie Poster

Hi,
I know this sounds like a repeated question but the tips in other threads didnt quite help me, so thought of asking again.

I have 2 tables 'tbl_AWB' abd 'tbl_flight'. Flight has the fields "FlgihtNo" (PK), "DepCityPort","DestCityPort", "DepTime", "ArrTime".

tbl_AWB has fields 'FlightNo', 'DepCity' and 'DestCity'.
The tbl_AWB is used to make a form 'frm_AWB'. When I make a new entry on the form and I enter 'FlightNo' i want DepCity and DestCity to be automaticlaly populated. How do i do it guys?

Thanks!

  • 1 Contributor
  • 0 Replies
  • 66 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.