Hi guys I'm doing my first form on InfoPath. I want to be able to have a drop down box to choose items from another list. How will I be able to do that?
EDIT: I managed to get it working by using a lookup column.
Another thing how can I filter certain items based on the status column? So the items will only appear in the dropdown box when the 'Status' column is Approved. The Status column is a choice column.