This may be a silly question, but is it possible to link specific records in a database to a particular form, so that by default they are always displayed using that form?
I’m asking this in relation to the equipment database I’ve imported from my previous database app (Bento). In this I list different types of technical equipment with their serial numbers, date bought, price paid, and technical specs. There are quite a few fields in common between different items of equipment, like a photo field and the first 3 items just mentioned; but for the technical specs I found I needed different forms for the different kinds of equipment: so I have separate forms for cameras, computers, printers and mobile devices; and a General form for everything else.
But then problem is that with Bento there was no way to specify that camera records must always be displayed using the Camera form, computers with the Computer form, and so on. It would seem clumsy to have five different databases for very similar types of data—and as I said, there’s a large degree of overlap between them. But as it is, I’m often scanning the screen for a particular type of info and not finding it—only to realise that, e.g., this printer record is being displayed with the Camera form, and cameras are not categorised as duplex or simplex!
I realise I may be going beyond what’s possible with a database app; but being so impressed with Panorama’s tremendous versatility, I just wondered if it might have a solution for this problem too!