Trying to get the previous field to default my next record.

S

sboyd

I have two fields in a repeating table to capture landing information
for flights, 1 is From Airport and the 2nd one is To Airport. I have
a drop down list to pick the airports. I have a rule for the From
Airport that says if the landing number is not 1 to get the preceding
To Airport. You should be taking off from the airport you previously
landed at. I have the following rule :

normalize-space(preceding-sibling::Flight_Leg/@To_Airport[1]) The
rule works for the 2nd landing but instead of giving the previous To
Airport on the 3rd landing it gives me the same From Airport that was
on the second leg.

For Example

From Airport
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Airline Flight Selection and Travel Request 5
What Function to use? 5
How do you a Macro to copy data into the next clear row each time 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Trying to get previous, next, first and Last record functionality 3
Linking from a mailing address in the database to maps.google.com 15
Go to previous workday if weekend 1
using an IF or AND function to get next largest value in list 1

Top