I'm new to Creator and just beginning to get my mind around it. I know its possible to combine records from different forms into a single list report so long as the records are linked such as a Department Form and Employee form. However, what I need to do is combine records from different unlinked forms into a single list report (or page) such that each row represents the record from a different form. Is this possible?
To be specific, I keep inventories of different types of media that fall into four categories - Film, Audio, Video, Drives. Each media type needs its own form since each have fields specific to them, but also have some similar fields including barcode ID, Title, Shelf Location, Media Type, and Format.
Currently I have separate reports for each media type. Is there a way to combine the records for each media type into single list report if the displayed columns are all similar (i.e., Barcode ID, Title, Location, etc)? If so, would it also be possible to include an action button to each record in the list that opens the record for that specific media type?