Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
9/9/2006 5:42:34 PM EDT
I am frustrated....hings
I am writng a pretty simple database. Heres the issue...

I'll try to keep it simple.

I've got my main table. I have one colum of "Gun Type"

I have a table set up for that populates a combox for me.

Gun Type

Semi Auto
Revolver

What I want to do is be able to "select" gun type, and then enter different variables like Caliber, Bbl length, etc.

How should I set this up?

Like this?

Gun Type
Semi Auto | Caliber | Bbl Length
Revolver

My final goal is when adding a record with a form I can: Select gun type, and the be able to enter separate values for each "type"

What am I missing here?

Thanks!

-Jared
9/9/2006 5:54:15 PM EDT
[#1]
Sounds like you want to make forms, not reports if you're trying to capture information.  Use forms to capture info, reports to display it.  Unless I misunderstood your question...
9/9/2006 6:39:05 PM EDT
[#2]
I'm sorry, My head is spinning.. Its fixed now.
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.