Require some advice on how to complate a small project
Hi all,
This is just a small request for advice and pointers on how I could go about comleting a relatively simple project. What it is I need to store records in a database, I was thinking an access databse would be the easiest. There will only be two Records "Make" and "Model". I need to be able to add, edit, search etc. these functions are relatively easy to implement I think. The part which Im not too sure about is how to write them to a file. it will be a text file similar to this format
var ModelsArray=new Array();
ModelsArray[ModelsArray.length]=new Array('FORD','FOCUS');
look forward to hearing the experts opinions and advice.
thanks in advance
R
Re: Require some advice on how to complate a small project
Table for manufacturers (make)
Table for models, foreign key to manufacturers
Form for searching/selecting/editing
On the for you can have abutton to export as a text file.
For outputting to text, read up on :
Open, Close, Print # (use strings)
Two forms, one for manufacturers (text box filter perhaps above a list box).
one for Models (uses a combo to select manufacturer? or text box filters) combo for manufacturer to pick when updating.
Preferably use ADO, but up to you.
Re: Require some advice on how to complate a small project
thanks for that is it easy to export the data into a text file in the format below doea anyone know
ModelsArray[ModelsArray.length]=new Array('FORD','FOCUS');