Separating records in a table

[madman411]

Hi All

 

I have a database which tracks the Quality Control process at a camera rental facility. Currently I have four tables - Cameras, Filters, Lenses, & General Inventory - which I have called Modules, as each table has a separate layout which is only accessible by the respective staff that QC's those particular assets. The respective records are imported in to their tables from an exported Oracle Excel sheet (i.e. camera bodies are imported under the "Cameras" table, filters in to the "Filters" table, etc). The problem is that importing, filtering, and deleting records in to the appropriate tables is very frustrating and time consuming.

 

I now want to have all the assets imported together in to a new separate table, but have an additional field within the table define what "module" they should be accessible under. For example, all assets that are camera bodies should be "tagged" as Cameras in this field, filters as "Filters" and so on.

 

What I cant seem to get a grasp of is how I can incorporate this in to my already existing set up. I don't want records tagged as "cameras" to be accessed via the "Filters" module though technically the filters and cameras are stored within the same table

 

Suggestions/help would be appreciated! I'm very close to finishing this database.

[Priyabrata]

Hi

You can create  a "Filter" table having a field (Global) through which you Enter the module Names using a pop up or dropdown (as preferred ) and relate the field with the Module tag of a table (Let it be "ModuleAll") which contains all the data from all the four different module tables.

 

And you can have a portal from the "ModuleAll" table in the "Filter" table layout where you can filter the Portal records using its Filtering field.

 

Hope it works and helps you

[madman411]

Thanks for your help, Priyabrata Sahoo.

 

So I've applied some of the changes and found that the Oracle system has already categorized the assets in to departments (which I originally called modules in my first post), so that already saves some time.

 

Unfortunately, using a portal row to filter the different "departments" isn't really an option. Presently, each layout returns each record individually, and there are numerous portal rows in place to display related data. I have adjusted the layout settings to display records from the new main inventory table, and have incorporated a global "department" field to assist in filtering out the unnecessary records, however now each separate "module" (layouts - filters, cameras, lenses, and general inventory) return all the records within the general inventory table. The filters aren't separated from the cameras, and so on.

 

I think I've confused myself by attempting to modify a setup that has been structured around my original design. Unfortunately I think I'll need to start again from the ground up to get this working correctly. It's key that only specific records are accessible on specific layouts (i.e., cameras on the camera layout).