Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PHP Runner

Status
Not open for further replies.

CecilXavier

Technical User
Oct 2, 2007
104
US
Hello all,
I am having a little trouble (Of course why I'm here) in trying to do something with PHPRunner. I don't know if any of you are familiar with this program. It allows you to streamline the process of using SQL and a web based interface to it. Here is my problem:
I want to set something up so that I can have 1 singular date, but multiple entries for activities on that date. Think of it like having a separate line for each car part you want to put in. But I would like it so that I only have as many lines as the items I put in, but I don't know until I'm finished how many line there will be. Am I making any sense? I guess I also need to know how I can design this so that, on the SQL side, it polls correctly when I try to run reports from it. Each one of these options could will be a search field. So when the field is populated it will open up a new field to be used, but they all have to be tied to one date.
 
I answered my own question. I created a seperate table and seperate entry point. I combined both tables to a view that allows me to view each document per entry of the original table. the view gets a bit long, but I can pull information from it now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top