I have an IP form with a drop down list for (Store Location:) and a repeating table with 5 columns (Asset #, Year, Make, Model, Serial #) below that. I would like for the drop down to contain a list of store locations and for the repeating table to be populated with data from a SP list when a user selects their store location.
I am trying to figure out how to populate the repeating table with data from a SP list based on the drop down selection (i.e. only the assets for the store that was selected in the drop down are displayed). Can anyone advise me on best practices for doing this? Can I do this with one SP list that contains all assets and stores or do I need to use 2 lists?
Thanks,
Andrew