kjjames

Hahaha! I told you it was messy! I would go in and try something to see if it would work. If it did, great! If not, oops! I am still such a newbie! It looks like I'm coloring with crayons! I cannot Thank You enough! This is exactly what I wanted to do. Those random fields you saw at the bottom of the Layout that you commented on were tests. I should have removed them from the Layout before I uploaded the database. The 2 that you have working on the primary part of the form, that is what I was hung up on. You understood my goal perfectly. And your explanation was very clear. You saw my Access background with all the connections in Relationships. In Access, nothing works unless it is connected. So, I figured that was my problem. I really need to stop thinking Access. And thank you for that offer on design and interface tips. I may take you up on that.

And please forgive all the extra stuff going on in that database. I've have literally been trying everything in it. And if you think I should start from square one, I will. I'm coming from an Access background. It's a little messy.....

Hello eos, Thank you for the welcome and the response! It was a great conversion to the Mac...once I laid hands on the iPod, then iPod Touch, iPad.....I was lost Okay, real world relationship. I have in my inventory of supplies surfaces, such as watercolor paper, bristol vellum, charcoal paper, and canvas to name a few. I will use these surfaces as a base for medium such as paints, artist grade colored pencils, graphite pencils. I also do some work with glass. So I would classify glass itself as a medium. Now, sometimes I work with different types within the medium....I might use oil paints, or water color paints. If I'm using water color paints, it'll be with water color paper. I think that gives you an idea. Now I'm sure you're thinking this is an inventory database to keep track of what I have used. Nope. It's to prevent me from buying duplicates! When my favorite on-line art supply house has a sale, I always take advantage. However, I always seem to buy those colors that I have in stock. Last time I purchases, 35% of my purchase was duplication. I have the cloned database with a few records in it for you. I've compressed it, but I'm having a problem uploading it. I think I need to .zip it. I'll get that up here ASAP for you. Thanks so much for looking at this! Karen P.S. WooHoo....file uploaded! Art Supplies and Tools Database Clone.fmp12.zip

I would like to apologize if I am not using the proper naming convention for what I am asking for help with. Until about a year ago, I was a PC woman, who had used Access forever. So, I'm having a little trouble with the same tasks or features having different names. So, please correct me! Here is my problem. My database (I'm the only user and it resides on my MacBook) is for my art supplies. I have my Primary Table, that pretty much holds all the data, related tables, and a few extra tables that I added (Vendor Table for example) for future use. My Primary Table is as follows: tblArtSupplies ArtSupplyID ProductCode ArtSupplyName ManufacturerID MediumID etc...... There are more fields, however I don't think they are relevant to my question. As you can see, there is a field, MediumID. I also have a table for that as follows: tblMedium MediumID Medium MediumTypeID MediumType I also have a table for Medium Type as follows: tblMediumType MediumTypeID MediumType I've related tblMedium:MediumID to tblArtSupplies:MediumID and tblMediumType:MediumTypeID to tblMedium:MediumTypeID What I am trying to do is this: When I enter a new, say, tube of oil paint to my inventory, I would like to go to my entry layout and: Enter the information pertaining to the paint, for MediumID choose Painting Supply (from a list of Painting Supply, Drawing Supply, etc.), then have that filter my choices in MediumTypeID to Oil, Acrylic, etc. I have tried following many of the samples that I have found, but I'm missing something. Maybe I've been breathing in too much Turpentine! I thank you in advance for looking at this. If I can provide further info, please tell me. Karen