zamzame

Well. That is a good idea. excellent actually. I didn't think about merging those tables.. But surely I can if I want to. Actually my database is quite different from my example.(I just wanted to simplify my question) Mine is an image database and I separated my DB into 2 parts. Data and Image. There are different data tables and those data should be separated into many tables. But I added tables which keep relationship information between Data and Image. As a result those 'connecting' tables consists of only two fields both are numbers (which is Data ID and Image ID) For example data no.2 matches to image no.5 Then in a 'connecting' table looks like Data ID | Image ID 2 | 5 .. and I made a 'connecting' table for each data table. But I might make one connecting table for all data tables. Well. Thanks for your tip really I feel like your tip opened my eyes into a new world. I should have considered this option. Now I have to figure out how I can make portals to evaluate whether a relationship information is about the tables they belongs to.

Hi.! I'm making lists of data in a layout. I can make a list of data in a layout but I can't figure how to make several lists on a layout. I am making two product tables named category A and category B(each data is a product) I want to show the whole lists (or the last 5 items) of category A and B.(in two separate list) For example, -Layout WholeProducts- ____________________ category A M&Ms Hurshys Biggy ... category B Coca cola Fanta Nestea ... ____________________ I want to create , modify, delete items in those lists as well as to see the two lists on a same layout. I did try to modify a 'table view' layout of <category A> to include a list of <category B>, but it just doesn't work well.(I can't create new records of B, only show the same number of products with the number of A, etc.) I also thought about making a portal, but how can I define the relationship if there isn't any relationship between the two tables(category A and category : -Should I make another table? -Also I think there will be some display problem making a portal, what if the number of data exceeds portal rows? Thank you for reading this.. Plz give me a hint-

Wow Thank you very much! LaRetta and Lee The tip LaRetta gave me was what I was looking for. Actually I wanted most but gave up this because it looked difficult to make. But with your help,I've made this. Also Lee, thank you for your tip. I didn't know there is an auto-enter text option. Thank you~ Have a nice day both of you.

Hello! I saw a movie file on filemaker from filemakerforums.com. In the movie, he has a field which shows 'Enter your name' And when he starts to enter his name into the field, the sentence disappears and field gets ready to receive input. I want the same thing, but there isn't any information about this simple thing in the movie. He was trying to teach a more difficult one without explaining how to make easy one, but I don't know how to make the simple one either. How can I make this? My field is a text field. Should I make the field a calculation field? I'm a very newbie and get no idea of making this. plz help me . Thanks~

Wow Thank you I haven't inputted any data yet. I wanted to make sure that all portals are working well before inputting data. I just made some records and now it works beautifully.

Hello, I'm making a database using portals. My Problem is 'I can't see anything in a portal' sometimes! But, this is not a problem of connecting or finding DB data. When I create a constant letter field (which you can make by clicking the button which face has 'A') and move into the area of portal(the portal container) Then , I can't see this 'Constant field' in the Browse mode Of course when I move the 'constant field' out of the portal container I can see it clearly. But when I try to put this field into another portal in the same layout , I can see it in Browse mode. I tried rearranging many times by moving back and forth, but obviously this is not a problem. I know This is just a small problem, but now very irritating me. Please help me.. I think this is just because of the some different options. But I can't find what 'the options'is. I'll really appreciate it if you give me a hint! Thank you~ .

ESpringer really thank you! Finally I did it! and I successfully made this just for an hour. (I was very busy and had no time to work on this.) Your tip was really helpful even though it might look just simple..(even to me haha) becuz I didn't know that is that easy ~ Moreover, I wasn't sure that my ideas were possible or not and Newell , thank you for your tip. I should check how to make that out. Thank you thank you

pzl anyone ~ help me ~

Hello~ I am the newbie of newbies. I am making a database with three tables(which is in two files) I am making kind of photo album. Tables: Data contains data of images Data-Image :a table contains relationship between data and image Image : contains images Relationship between three tables are Data Id <-> Data-Image_D (one : many) Image Id <-> Data-Image_I (one : many) Data and Data-Image is in the same file and Image is in another file table <Data> and <Image> has own serial numbers(which is IDs) and <Data-Image> table has connecting data between <Data> and <Image> i.e <Data 3> has related to <Image 5,6,7> , then there are three entries in <Data-Image> like <data> | <image> 3 | 5 3 | 6 3 | 7 and I want to see images 5,6,7 in a portal of Data 3 layout. How can I make this??? Plz give me hint... I am not even sure whether this is possible or not..

Hello~ I have a question. I am in Korea, and I found when I import a file with Korean filename and show the filename in the records(not having problems with importing those files with Korean names) or when I use value lists with Korean text to use in Radio buttons, check box etc., the letters become all &#9633;&#9633;&#9633;(empty squares) . I don't have any problems with typing Korean in fields and They are saved well, and are shown well when I reopen the files. The problems occur only when including importing behavior.. How can I solve this? Currently in Korea, there isn't any vendor of fileMaker. I bought a Filemaker in USA. This mean no special language support for Korean... I haven't updated FileMaker and my FileMaker is pretty much the same with the FileMaker CD. If I update my fileMaker Can I solve this? or If not, FileMaker have plan to develop and provide such support? Thank you in Advance ~

Also I have a design.. How can I become a newbie in this forum? I'm still stranger... hihi... I want a level up-

Hello I am totally new to fileMaker. What is the difference between making database of several files and tables? Is there any limitation to any of them? This might be in the manual , But plz be generous.. running out of time.. Thank you very much~

Thank you Bruce~ I really appreciate. Then I don't have to divide image and data for speed.... less work..!

Hi all, I am a newbie to FileMaker, although I have some basic knowledge about what Database is.. (DB concept like relational DB .., SQL, etc) I am creating an image library database(which also includes information on those images) consisting several tables. The database is about food. The tables are like <recipe>, <package of food>, <restaurant>, <tableware> etc.. Each records in those tables has one or more images and each images might be around 800k and at least 10000 images total at the moment. I expect around 3-40000 or more images in the near future because we are planning to input much more data in the future. I know that FM7 supports to include graphic images in records and I am using it. Now I am creating schema and because this is image database, I am worried about speed of browsing each records. Since I'm newbie I have no knowledge what are the imporant factors concerning speed. I should choose whether 1. to make each table include image 2. to make table not to include images, instead add table <image> and separate images from the other database as a separate table and show those images in a portal. (As you might know, I should create a relation(?) with <image> and other <data> tables) 3. or any other opinions? In this database, Images are the most important part, and time to load image is important. I will mostly use the database to find the images with several options like images of the same food cordinator, of the same colortone( I will save this information in data) and might result in hundreds or thousands of records. If I include all the images in records, wouldn't it be too slow to browse? The database file size might be several gigabytes. I expect the second option above to make separate table containing images need extra work, and I wonder it deserves such effort. I expect the second option might be better on the 'speed' aspect because there is no need to load all images in the table I use.. Am I right? Also, if I separate image and data, and I include portals in 'data' table to show images. Will it be take a long time to find and display those images? Or Do you think these two above options bad and I should find any other way like separating all those tables into sevaral database files?? Woo.. I have several questions. Sorry for my poor explanation because of my poor knowledge and english skills. Plz give me a hint... Thanks a lot~~~