Hi all,

Quick question that hopefully has a simple answer.

I'm in the planning stages of an asset/customer/invoice relational dbase.

How can I build an asset database that has individual items and groups of items - eg single items such as CD player, amp, TV, etc. and a 'kit' like an av trolley that is only ever signed out as a group of items? Like having the trolley as a main item and the TV etc as sub items.

Any help appreciated.

I would make this 'kit' by adding a separate item in the Asset table to represent the kit, linked with a self-join to the included Asset items. Use a field Type to indicate which Assets are meant to be used only in kits and which are not. If you are using a value list to choose the assets for the checkout, you can have it show only those Assets that are kits or not 'kit only'.

Thanks Ender.

I will try this out next week when I start building the db. Great to know there is an answer, i've been trying to figure this in my head for weeks. I'm just brushing up on my db theory and planning it all out right now.

Cheers,

The "kit joins" are a separate table (or file in 6), with just the 2 IDs in each record (kit ID and item product ID). As there are several items in a kit, and each item could conceivably belong to multiple kits (at least this is supported). A kit, as Ender says, is a product, like any other product, with it's own price; except it has multiple items. You can show the items in a portal, and also see their inventory level (easily in 7), which may be useful, as you can't sell a kit if any one of its items is not in stock.

I am a "newbie" to the Filemaker System.

In the Filemaker Pro 7 System, I am using the Course Tracker inside of the Filemaker K-12 Starter Kit.

Can anyone explain how to have the system accomodate the PASS/FAIL designation in the calculation of the GPA.

Thank you for any help.

Kevin12, I'm sure we won't mind helping you, but this post has nothing to do with the current thread.

Please delete your post here, and start a new thread in an appropriate forum (like Define Fields.)

Ender

I don't know how to start a NEW thread.

I can't find the FAQ's to learn the BASICS.

Can you please point me in the right direction?

Thanks

Kevin:

Welcome to the Forums.

Click on "Forums" at the top of the window, then pick the category/forum which is appropriate for you. Ender suggested "Define Fields." You'll find a link there that says "post." That's how you start a new thread.

Also, at the bottom of the main Forums list is the "about these forums" (or "self-help" or whatever it's called) section.

-Stanley

Stanley

Thanks

I will check it out and then do what Ender requested.

Thank you very much

Kevin12