Jump to content

Bruno Dini

Members
  • Content Count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Bruno Dini

  • Rank
    novice
  1. Hello guys, Thanks for the answers, they all were very helpful, and help me understand some features here. I tried both ways and all worked very fine, but I'll be working with comment's way, wich I think is simpler. Thanks a lot.. :-D
  2. Hello, I'm developing a solution to organize my office, but I'm having a little problem with one script, that I believe is very simple to accomplish. I have two tables Projects and Jobs that are related with each other. I can create many jobs that are related to a specific project. Project and jobs have a status field, that can be Open or Closed. My script is to set the status closed to the Project, but for that I must be sure that aren't any open jobs related. The script works OK when there's an open job there, it displays a Custom message saying that are some jobs open and the
  3. Hello. I Tried your tip and it worked perfectly. Quite simple to accomplish also. Thanks a lot!
  4. Hello, actually I want to create a report based on the records that are displayed on that portal. I believe this solution you gave me will work fine. I'll try to do this and I'll post a feedback about it. Thanks a lot...
  5. Hello all! I'm developing a simple solution for my office and I need help in one thing. I'm making a portal that will display the tasks for all employees. This task portal is filtered by employee name and task status through two drop down menus. I need to be able to create a report with this data. I must be able to select the employee, the task status and print a report. But I can't figure out how to create a found set of this records, based on the data displayed in the portal. Is there a way to do that? I'm newbie on scripts. Thanks in advance.
  6. Another question, due to this solution, can I avoid the "clicking outside a field" to commit a record? I want the record to be commited only when the button is pressed.
  7. Hello all! Thanks all for the help. I solve that the way comment said, not commiting automatically the record. It worked perfectly for me. By the way, this serial number is for identification only, I won't use it as my primary key.. :-D Thanks again for the help!.
  8. I understood. So I need a auto entrer serial field to by my primary key, and another field to be my code. Sorry I'm newbie, but how can I use the max function to do this code field? Thanks in advance.
  9. Hello, I am making this database, and one of the features of it will be a clients database. I don't want everybody to add clients, but I want everybody to see them. I made a layout with all the information, that cannot be modified in browse mode with an "ADD" button. When pressed this button will create a new record and go to another layout modifiable in browse mode, so the person can put the information. This layout has 2 buttons, one OK button that will lead to the information layout and commit the record. Now comes the question. I have another button, called cancel, this b
  10. Hello, I tried to do this "universal Person ID". I don't know if I'm doing something wrong, but it didn't work out. The partners and clients already have their IDs: for example C001 for clients and P001 for partners. I didn't understand how can I combine this atributes in the payments table.
  11. Hello, I'm trying to do this but I can't figure out how. I have this database with one Table for clients and another for partners. Insite this tables I have the fields clients_id and partners_id I wanna make now a payment table in this database, but the payments can come from the partners and from the clients. Is there any way that I can show both fields (clients_id and partners_id) in the same drop down list? Insite the Payments table? Thanks!
  12. Would it get in conflict with the previous numbers? For example, I already have the 0002 job in my database, if I reset the counter it will overwrite or duplicate this number?
  13. Thanks! It worked, thats exactly what I was trying! It will work well until december ;-) Just hoping now someone can come up with a solution for the reset thing. Thanks for now.-D
  14. Hello all! What I am trying to do is very simple, but I can't figure out how. I have this joblist, and every new job creates a new serial number (I'm using an "auto enter serial" for this field), but I need to put the year after this serial number, like this "0345/2007", and if possible, resets the count next year and so on. Is there any calculation that can be done? Thanks!
×
×
  • Create New...

Important Information

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