Jump to content

Mian Umar

Members
  • Content Count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mian Umar

  • Rank
    novice
  1. Hello All. I Explain in a very simple way hope u understand my problem. (One thing I know all about Relationships And how much Fields Are using by me). Thats why I Tell my Problem in a very simple way So Here it is Let I have A Movie Name Field And Three Records In It. ( Want to send on RENT) A Issued on 1 DEC 2006 B Issued on 2 DEC 2006 C Issued on 3 DEC 2006 OK NOW So The Problems ARE: 1. A is already on rent, So How i control that When End User Again Write A in Field its Show Its already on Rent.(If I perform Unique Value Then Comes Another Porblem That is (See 2. Pr
  2. Try it with two tables — one of which lists products and categories, and could consist of only those two fields (although it could certainly have more). A list view might look something like: Kitchen Appliances*****Blenders Kitchen Appliances*****Toasters Kitchen Appliances*****Coffee Makers Garden Tools**********Rakes Garden Tools**********Shovels Then you have your second table, which is the one in which you want to specify a category and then pick products from a value list constrained to those products in the selected category. Let's call that table "Invoice Line Ite
  3. I am very Thankfull to u. But I dont understand how u mange it How u store Genre & Movie Names In the Tables? bcz in Video Table there is only one record Plz Explain Some Qlues how u Make This one. I am very thank full to u Waiting ur reply. Mian Umar
  4. Hello All. Let Suppose I created 2 Tables, named by Movies and Rental Repectively. And Suppose the Fields are for table Movie Movie No. Movie Genre.(Action, Romance & Adult In it) Movie Name. (10 Movies belong to the genres mention above) And Table Rental. Rental No. Movie Genre Movie Name So I want When i enter in RENTAL TABLE And Select Genre as Romance, And when i enter Next Field (Movie Name) Then It Show me Only the Names of that Movies that are Romance Genre, As well as I Select Genre as Action, And when i enter Next Field (Movie Name) Then It Show me Only t
  5. Hello All. I created tables 4 movie rental system. Now Once a movie is on rent then how i check it is on rent so its not sent again on rent. Unique value is solution of this But when movie back then how i check its back And then Now this can be sent on rent. I have have Issue Date And Return Date Fields Is it possible i Check this with Return Date With comparison of System Current Date. Plz Tell me If Script or Function available then Tell me. Thanks Mian Umar
  6. Thanks I found that one. And whats another Problem. Tellme Function Name That Check This Item IS already exists in this field And u dont enter again. FUNCTION NAME!! Thanks Mian Umar
  7. Hello All. I want to run a script file On a Field (when User Move to Next Field) How is it possible in FILEMAKER 8.5 And Also Is there any Funtion in FIleMaker That We Check Is This "ITEM" already Exist in this field u cant enter. (Remember SCRIPT Fucntion not Field Options) Thanks Mian Umar
  8. Thanks Very Much. I am trying If i got Problem again then i post again Thanks Once Againg So Brother I got Problem I created these three table. I want to tell u That I am begner of FileMaker. So please dont mind my posts. I apply Checks Like UNIQUE VALUE, Not Empty And Only Numeric Values IN Fields. Title ID ( In Title Table) Title ID & Item ID ( In Copies Table) Customer Id ( IN Customer Table) Item ID, Item ID, & Rental ID ( IN rental Table) So is Foreign Key Automatically Applied on it? And also Explain some more about Control, Issuing A Movie. Many Th
  9. I am trying to creat a movie rental system. SO lets suppose 4 fields in one table. Movie No. Movie Title. Issue Date. Return Date. And UNIQUE VALUE option check on both Movie No. & Movie Title. And I enters Data As u say Its Uniquly saved. Now the problem is that When One movie (Movie No.2 And Title is "XYZ" Issued on 12-11-2006 And Return on 15-11-2006). So Date is Saved If I again Sent this movie on rent Then Because of Unique Value Is Check Its not accept This Title Or Movie No. Again So How I Handle This Problem. I want Sent this movie Again on RENT. Thanks Plz Re
  10. So Sweet Thanks very Much I done as u say its work. But I explain it again. I am trying to creat a movie rental system. SO lets suppose 4 fields in one table. Movie No. Movie Title. Issue Date. Return Date. And UNIQUE VALUE option check on both Movie No. & Movie Title. And I enters Data As u say Its Uniquly saved. Now the problem is that When One movie (Movie No.2 And Title is "XYZ" Issued on 12-11-2006 And Return on 15-11-2006). So Date is Saved If I again Sent this movie on rent Then Because of Unique Value Is Check Its not accept This Title Or Movie No. Again So Ho
  11. Hello All I Have a Problem. That is Let Suppose I make a Table Student And Its Fields Are: Name City Now I am Entering Records Like First Record Mr A XYZ Second Record Mr B XYZA Third Record Mr C NMJH The Problem is I want to check On Every New Entry Is This Name Already Exists or Not If The Name Already Exists then Messege Comes Sorry The Record is Already Exists So it cant b Saved And If its New Entry then Save That Entry. Like If i again enter Name MR A then msg comes Sorry Its already exists So its cant be save. Try with new name. I am verythan
  12. Thanks 4 reply. Let me explain Table Named By Student Fields are Rollno. Name. Address. Phone No. And i add 10 Records in it. ok So I want All these records show in Form view ( that is simple and I move next or back by clicking on book forward or back) I also want Table view of it In that Form Mean Table within the Form. And if i search one record by Select any fiels Its show me only that Record. Understand or No. Plz Reply i will b wait Thanks. Umar Farooq
  13. Hello All. Please help me in using Portal tools How many Relation ships can be defined in it? How mayny Table r used in it? I create one Portal But its not very fine its not hold entries like grid what can i do ? PLZ help Umar Farooq
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.